Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problem in Compound Report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem in Compound Report
 Login/Join
 
Silver Member
posted
Hi,

I have compound report in HTML format with three reports and graphs. I am not able to do drill down on Graphs. Can it possible? If any example then give me.....
 
Posts: 30 | Location: India | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
Hi Goldy,

Is this still an issue for you? Have you tried search on Focal Point posts? Please see if the post below can be of any help.

drill down/conditional styling in a graph
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/
m/7371018331/r/7371018331


There are also quite some documents on Tech Support website that deal with drilldown on graphs. Let me list a few of them and see if any of those can be useful to you or give you some pointers.

How to create a Drill-down Request on a Graph?
http://techsupport.informationbuilders.com/sps/92261055.html

How to create a drilldown on a graph?
http://techsupport.informationbuilders.com/sps/61991030.html

How to link a DrillDown report and graph on the same page
http://techsupport.informationbuilders.com/sps/11662049.html

The steps to create a drill down from a graph to a report
http://techsupport.informationbuilders.com/sps/81111094.html

You will need to have a tech support userid/password to access the above documents.

Hope this helps. Big Grin

Cheers,

Kerry

This message has been edited. Last edited by: Kerry,


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Silver Member
posted Hide Post
Hi Kerry,

I think you are not getting me. I am talking about Drilldown on Graph in Compound report where more than one reports and Graphs in one report, where we hold graph as a gif for creating compound report, so how can possible to drilldown on gif..

Regards,
Goldy
 
Posts: 30 | Location: India | Registered: February 23, 2005Report This Post
Gold member
posted Hide Post
Hi,

If you're creating an HTML compound report, then it is possible to drilldown on graphs. You can create the layout with Resource Layout Painter or just create the reports and graphs normally and save them with ON TABLE/GRAPH HOLD AS xxx FORMAT HTMTABLE.

The report:

TABLE FILE EMPDATA
SUM SALARY
BY AREA
ON TABLE HOLD AS REP1 FORMAT HTMTABLE
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
TYPE=TITLE, STYLE=BOLD,$
ENDSTYLE
END

The graph:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 300
ON GRAPH SET HAXIS 500
ON GRAPH HOLD AS GRAPH1 FORMAT HTMTABLE
ON GRAPH SET STYLE *
TYPE=DATA,ACROSSCOLUMN=N1,TARGET='_blank',FOCEXEC=DRILL1(XCOUNTRY=A1),$
ENDSTYLE
END

Drilldown fex (drill1):
TABLE FILE CAR
SUM SALES
DEALER_COST
RETAIL_COST
BY COUNTRY NOPRINT
BY CAR
BY MODEL
ON COUNTRY SUBTOTAL AS '*TOTAL'
WHERE COUNTRY EQ '&XCOUNTRY';
END


After this create an html-page and place the reports e.g. inside <td>-tags using syntax !IBI.FIL.xxx; like this:

-HTMLFORM BEGIN
...insert html and body -commands here...
<table border="1">
<tr>
<td valign="top">
!IBI.FIL.REP1;
</td>
<td>
!IBI.FIL.GRAPH1;
</td>
</tr>
</table>
...insert html and body -commands here...
-HTMLFORM END

Creating a drilldown from an image in a pdf-report could be possible, I haven't really tried it. Anyway, I think that if you create a pdf compound report with graphs, you can't create a normal drilldown from the graph, like in the example above.

Hope this helps.
Mika
 
Posts: 58 | Location: Sydney, Australia | Registered: April 22, 2005Report This Post
Expert
posted Hide Post
Hi Goldy,

Have you had a chance to try Mika's suggestion?

I searched "gif with drilldown" on Information Builder's online documentation and came across the following:

"How to add a drilldown to a GIF in a TABLE request"
http://techsupport.informationbuilders.com/sps/83381023.html

In addition, you may also want to check the WebFOCUS technique page at http://techsupport.informationbuilders.com/tech/contents/wbf_tcn_toc.html and review the Reporting/Graphs section.

Hope this helps. Big Grin

Cheers,

Kerry
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problem in Compound Report

Copyright © 1996-2020 Information Builders