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.....

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.

Cheers,

Kerry

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

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

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

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.

Cheers,

Kerry