I know this question has been asked a lot, I just want to confirm if it's the answer for Sql Server 2008.
I have a client who is running Sql Server 2008. I created reports with multi-value parameters. One report has a drill down to another report.
To pass the multi-value parameter to the drill-down I use the following:
Right click on report item to link to drill down
Click on 'Action'
Click on 'Go to Report'
Select the report I want to drill to from the 'Specify a report' drop down
I add a parameter name and in Value I use the expression:
= SPLIT(JOIN(Parameters!<ParamName>.Value,","),",")
In Sql Server 2016 this works fine.
In Sql Server 2008 it just does nothing.
Is there a Sql Server 2008 answer to this?