problems with report

Hello,

I have a report in Matrix form. Now i need a report in a way that when i click on any item in my column ,another report should be generated with all the data related to it.

For example below is a matrix report

A B C

X x1 x2 x3

Y y1 y2 y3

Z z1 z2 z3

Now when i click on 'X' i need a report with data x1,x2,x3 .

So my question is how do i do that. Should i create another report with with this data and just link it or can i dynamically create a report by clicking on X or Y or Z .

This matrix report takes parameters of startdate and enddate so i need to pass those to the report produced by clicking on X or Y or Z.

Please help me out with this

Thank you,

I do not know if this is the correct way to go about it but I am thinking that you could create the other report as you mentioned, then use the "Jump to report" to jump to the other report when it is clicked on.|||thx for the reply kimberly. But how do i handle the parameters. The matrix report is generated for a date range for example 'jan 1st 2005' to 'dec 31 2005". when i click on X and suppose i created another report and apply the 'jump to' property can i pass this start and end date parameters to that report so that i get X report form 'jan 1st 2005' and 'dec 31 2005' which out entering the parameters again.|||I tried it and it seemed to work. Properties of text box that you want it to work on when clicked-Navigation-Jump to report-(ReportName) and then it gives you the option to set the parameters- on the value side-go in to expression- pick parameters and you will see the parameters that you are using in the first report- that should feed the parameters chosen in the first report in to the second. (there may be an easier way for what you want to achieve)|||

Thx kim, its working now.

thx for ur help

|||You are welcome. I'm glad that it helped. There probably was an easier way, but I'm not sure how else to do it.