Interactive report

[saumil287]

Hello friends,
I know the concept of drill through. when clicking on chart takes u to the another report(say list), But I want the same thing to be in one report for eg When I click the specific bar of a chart, the corresponding list should be displayed below the chart. Is it possible? then how?

[ksr]

It is possible....

Self drill through....

we have a tutorial on self drill through which you can see in the following link

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id27706cr_rptstd_modrep_create_drill_throu.html

regards
KSR

[saumil287]

Thank You very much for your reply. I'll just go through the link you provided me.

[saumil287]

Hi ksr
I have created a report containing a column chart and a list with column chart as drill through on productline.

for chart I have drag the following query items as shown
y-axis:Revenue
Series:Region
Categories: ProductLine

List report containing ProductLine,product name,quantity and gross margin.

When I click the specific ProductLine for 1st time, the list displays the details for that productline, On clicking the other productline from chart does not drill through to details of that product line.

So can you guide me on the same.

Any help will be appreciated
thanks in advance

[ksr]

while applying drill through, in the drill through defination box, set the ACTION  to "Run the report" and save the report

run the report again and test it!!!

[saumil287]

Hi I tried the same thing u mentoined but not worked, then I added a value prompt associated with existing parameter for Product line. I chnged the value prompt property for visible to no, Required to no, Adnorments to yes and got the required result.