[Solved]Drill-through behavior in Report Studio dashboard report

[shantar28]

I have two list reports in a 2-column table side-by-side.  The report on the left is a summary, one on the right, detailed.   There is a parametrize filter setup on the detail report to the right and drill-through has been set up from the summary to the detail report.  The filter passes a simple Product_Code query item as the drill-through.

There challenge here is to drill though on the summary list, but showing the target only after a drill has been performed.

For example, the initial view when this dashboard report is executed, is the summary list with the associated columns and the data, but only the column headings without data are shown in the detail report to the right.

When a user drills through on the Product_Code on the summary report, the detail report would automatically show the resulting data following the drill.

I know this behavior is possible to achieve as I've run across either a KB, Multimedia KB, or SupportLink article, but now I cannot recall where.


Any advice is highly sought out and appreciated.


Cheers!
Shawn

[mrcool]

Y dnt u place the detail list in a conditional block...if  u have limited number of product_code u can create varibale with that and try....

I thnk u can also giv the master-detail relationship between the summary n detail tables....

[shantar28]

Thanks for the reply and your suggestions.   What would be the expression definition in my conditional block as per your suggestion?

[mrcool]

Hi..Here is the sol...hope this works...
Take detail report in conditional block.Create a boolean variable some ?select?=1 then (1)
else (0)
Wen giving drill through to the  report hardcode the ?select? value =1 and u will
have parameter ?productcode?=product code
here U will drill through to the same report.
So wen u click on product code,respective ID passes to the ?productcode?.
By default the ?select? value will be 0 where u can hide the list or in ur case u can have
list headers...

[shantar28]

mrcool,  thanks so much for your help.  You've definitely steered me in the right direction.

Cheers!
Shawn

[mrcool]

U r welcome...Close the topic if ur problem is solved....



Mrcool

[shantar28]

mrcool,  I've searched hi and lo in the forum Help and within posts, but I couldn't readily find any info on how to close a topic on Cognoise.

Thanks,
Shawn

[mrcool]

  Just modify ur subject in 1st posting as [Solved]Drill-through behavior in Report Studio dashboard report...



Mrcool.....