Right click the cell you want to use to go to the other report
Select Text Box Properties
Select Action
Select Go to report
Specify a report and select the one you created that you want to go to.
Note:
The report you are going to needs to have the same settings as the parameters on the main report.
on the Go to report create the parameter with the same name as the main report
make it the parameter multi-valued
create a DISTINCT list data set for the multi-valued parameter to select from
i.e. SELECT DISTINCT COMCDE_01 FROM [TABLE OR VIEW NAME]
I also trimmed it to make it look better in the parameter drop down.
i.e. SELECT DISTINCT RTRIM(COMCDE_01) AS COMCCDE_02 FROM [TABLE OR VIEW NAME]
add the SQL IN statement in the Where cause i.e. WHERE COMCDE_01 IN (@COMCDE)
----
Click the Add buttom
the drop down will pickup the parameter from the Go to report
Click the Fx
Use =Split(Join(Parameters!COMCDE.Value, ","), ",") expression to create the multi-value parameter list that the Go to report will use.
Click OK
I had to set it up like this to make it work right for my DB
Hope this helps,
Vincent Stefanetti
