question

Da1andonly2013 avatar image
Da1andonly2013 asked

Pass a multi-valued parameter to drill through report

Does anyone have an idea on how I can pass a multivalued parameter from the main report to the drill through report while making that parameter remember its last chosen value? For example, I currently have a main report which has a multi-valued parameter that lets me choose which apps I want to see data for and then it shows me a total aggregation of its usage throughout the year in a line chart. I also have an action setup that will allow me to run the secondary report (which is also a line chart) with its own ‘date’ parameter that allows me to show a much more detailed specific usage of these apps by days. So the selection of the app(s) in the previous parameter from the main report should be locked in and passed to the second report which will trigger the date parameter and allow me to choose a date to see data for that specific app(s) on that specific day(s) Thanks in advance for the help! :D
ssrsparameterspass
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
This is a bit 'hacky' but could you place a text box on your main report and set it's value to be the parameter value and then use the textbox value as the supplier to your sub-report ...?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I have never used a textbox with a parameter before, could you be a little more clear please and my report doesn't have a sub-report, instead the main report has an action which will take it to an entirely new report within the same report server project.
0 Likes 0 ·
dmedici avatar image
dmedici answered
The sub-report should display the multiple values selected in the parent parameter, by default, if they are being passed correctly. If your main report's multi-value parameter is @AppList, create another multi-value parameter in the sub-report, let's call it @AppListSub, without any values in it. Back in the main report, right click the Expression or textbox > Properties > Action > Go to report. Specify the report and Add the parameter. In 'Name', select 'AppListSub', and in Value, use the expression =JOIN(Parameters!AppList.Value,",") This will ensure the multiple values are passed as a string to the child report. 'App1, App2, App3,' etc. Not sure how your data is being pulled in your sub-report dataset, but if it's a query, it should use WHERE App IN (@AppListSub) You can also configure @AppListSub to be a 'Hidden' parameter so that users can't select or deselect more apps when already viewing the sub-report.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.