Passing Values from Records into URLs on the Associated Pages

Example 1: Pass a Single Value Parameter into a URL

Suppose that you have created a report and the report contains a parameter (P0) that accepts an entity key of Full Inspection family record. When you provide an entity key, the report displays data for Full Inspection record. You can create a link in the Associated Pages pane so that you will be able to view this report whenever you are viewing a record in Full Inspection. To do so, you would construct a URL as follows:

#ssrs/viewer/Public\Meridium\Modules\Inspection\Reports\Full Inspection Report/P0=[ENTY_KEY]

#ssrs/viewer/Public\Meridium\Modules\Inspection\Reports\Full Inspection Report specifies the report to open in the Report Viewer.
Public\Meridium\Modules\Inspection\Reports\Full Inspection Report is the Catalog path and file name of the report that you want to open.
P0 specifies that you are supplying a value for the first prompt in the report.
[ENTY_KEY] is the variable that will be replaced at runtime by the entity key of the actual Full Inspection record that you are viewing.

Example 2: Pass a Multi-Value Parameter into a URL

Suppose that you have created a report and the report contains two parameters. The first parameter (P0) accepts an entity key and the second parameter (P1) accepts a static value. After the P0 and P1 parameters are provided, the report displays data for Full Inspection record. You can create a link in the Associated Pages pane so that you will be able to view this report whenever you are viewing a record in Full Inspection. To do so, you would construct a URL as follows:

#ssrs/viewer/Public\Meridium\Modules\Inspection\Reports\Full Inspection Report/P0=[ENTY_KEY]/P1=[Value]

#ssrs/viewer/Public\Meridium\Modules\Inspection\Reports\Full Inspection Report specifies the report to open in the Report Viewer.
Public\Meridium\Modules\Inspection\Reports\Full Inspection Report is the Catalog path and file name of the report that you want to open.
P0 specifies that you are supplying a value for the first parameter in the report.
[ENTY_KEY] is the variable that will be replaced at runtime by the entity key of the actual Full Inspection record that you are viewing.
P1 specifies that you are supplying a value for the second parameter in the report.
[Value] is the static value that you provide to open the report.

Note: If you do not provide any static value for this parameter, then a window will appear and you will need to manually select the value for P1.

Example 3: Pass a Multiple Value Parameter into a URL

Similarly, in the previous example, if P1 accepts multiple static values (Value 1 and Value 2), then you can create a link in the Associated Pages pane so that you will be able to view this report whenever you are viewing a record in Full Inspection. To do so, you would construct a URL as follows:

#ssrs/viewer/Public\Meridium\Modules\Inspection\Reports\Full Inspection Report/P0=[ENTY_KEY]/P1=[Value_1]/P1=[Value_2]

#ssrs/viewer/Public\Meridium\Modules\Inspection\Reports\Full Inspection Report/P0=[ENTY_KEY]/P1=[Value_1]/P1=[Value_2] specifies the report to open in the Report Viewer.
Public\Meridium\Modules\Inspection\Reports\Full Inspection Report/P0=[ENTY_KEY]/P1=[Value_1]/P1=[Value_2] is the Catalog path and file name of the report that you want to open.
P0 specifies that you are supplying a value for the first parameter in the report.
[ENTY_KEY] is the variable that will be replaced at runtime by the entity key of the actual Full Inspection record that you are viewing.
P1 specifies that you are supplying multiple values for the second parameter in the report.
[Value_1] and [Value_2]: are the static values that you provide to open the report.

Note: If you do not provide any static value for these parameters, then a window will appear and you will need to manually select the values for P1.