March 1, 2011 at 2:32 am
Hi all
I have a graph and on that graph i have got an action which goes to a sub report.
The sub report expects a parameter to be passed to it from the graph.
my problem is how can i pass only certian values for the passed parameter.
For example
The main graph is a column graph displaying band data.
the parameter i'm passing from graph to sub report is called Band and it may have the any of the following values (A,B,C,D,E,F,U,T).
When clicking on the specific column on the graph, all i want the sub report to display is a detailed report for U or T (depending on which column the user clicked on... if the user clicks on column displaying values for U, i want the sub report to display the detailed report for U)
I have tried to use the omit function on the series property inside the action tab but no luck, can anyone help
thanks
March 2, 2011 at 2:35 pm
If the user is clicking on a bar to find the detail inforamtion, the better terminology for what you want is a drill through report (sub reports are permanently imbedded within another report)
First go to your drill through report and set up a parameter so that only one band's details at a time can be shown. This will likely be based on the field that shows their name - let's call it [Band Name].
In the primary report, right click on one of the bars in design tab, go to Series Properties, Action.
Click on Go to Report. In the drop down box select your details report (ie the one you want to drill through to). The final bit is to choose the field you will use to pass a parameter to the drill through report - ie [band name]. It should appear in the drop down box of the Value area or click on the fx to find it.
This means when a user clicks on one of the bars, SSRS automatically launches the drill through report and automatically inserts the bands name into the paramter of the drill through report
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply