How to pass a multi-valued parameters from a sql store procedure report to the parameter of the second (linked) report? For example the first report is a "Fiscal Year" report and one of the field, "Fiscal Year",in the report's tableis a hyper-linked to the second report, an "Account Period" report. The second report can be opened byITSELF or opened through the first report as a LINKED REPORT. The second report has several pararmeters, Fiscal Year, Account Period (multi-valued parameters)...etc. If the user selectedthe fiscal yearhyperlink in the first report, it will pass that fiscal year to the second report and it will pre-selected that fiscal year in the second report parameter. However how to passALL the account periodsfor the fiscal year selected?A sql store procedureis using this report parameters, fiscal year,account periods...etc, for the second report dataset. Thanks

Hi , multi-valued parameters through a stored procedure can be passed by using the join clause. For instance if your parameter is named account, the expression would be =join(parameters!account.value,",") The expression should be placed within the parameter dialog box

Hai,If you want the second parameter to be a multi value parameter then you should change your Sub-Report Query/SPROC a little bit. If you want all the values then the code should be like...Create PROCEDURE @Parm1 varchar(100),@Parm2 Varchar(100)ASSELECT ColumnNames,FROM TableNameWhere ColumnName1 = @Parm1 AND @Parm2 = (Case When @Parm2 = 'All' Then @Parm2 Else ColumnName2 End)ENDHope helpful...Thanks,Pavan

Hello, I know this thread is rather old; however, I have attempted to use the =Join(Parameters!ArgListDirectorIDs.Value, ",") in my expression for the parameter in my linked report (SSRS 2008). When the linked report executes, the parameters are displayed and the @ArgListDirectorIDs field has no values. The user must select the values again. I even tried creating a report variable with the same function, displayed it on the report to verify that the values looked correct (they did) and then tried passing that report variable to the linked report's parameter. That produced the same result. Any help would be appreciated.

I found another forum thread that had my answer: =Split(Join(Parameters!location.Value,", "),", ") The forum thread was entitled: SSRS 2008: Passing Multiple Values from Drill Down Field in Matrix Report to Linked Report (Drill Through) This was the link: http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/b092840b-e03b-49c4-b710-fa23e4cddbd9