Charting...jump to report -- sql server reporting services

Andre
7/21/2005 10:05:02 PM

I have a chart with a number of categories, and a Jump To Report action
defined. The Jump to report is a table with details of the data.

I would like to set it up sothat the user can click on a category, and only
the details of that category are returned in the Jump To Report. Is there
any way of setting it up like this.

I have everything working, except I am getting all records in the detail
report, not only records from the selected category.

Thanks in advance

Robert Bruckner [MSFT]
7/25/2005 8:27:17 PM

You will need to add a parameter on the detail report and provide the
current category id on the JumpToReport parameter page of the parent report.
Also, in the detail report you will need to have a parameterized query to
only retrieve the data based on the category id.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Charting...jump to report