If you are unable to create a new account, please email support@bspsoftware.com

 

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

Started by shantar28, 17 Jul 2006 03:58:37 PM

Previous topic - Next topic

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

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



Mrcool.....