How to Pass Multi-Valued Parameters to another Report

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

About Vincent Stefanetti

Vincent Stefanetti Senior Consultant MAX Manufacturing Software Working with MAX and Related Technologies Since 1987 MAX ERP System Implementations and Projects MAX, Dynamics GP, Synergy, Event Manager, Crystal Reports, SQL Reporting Services, Database and System Migrations and Updates, MAX Training Classes - All Levels, Custom Reporting.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply