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
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.