PCRReportParameters.xml
To enable check box parameters to scope down the report, you must modify the parameters in the PCRReportParameters.xml file located at [Install Path]\Core\bin\PublishCustomReports. The parameters in this file are explained in the table:
Attribute | Value |
---|---|
File Name | Name of the RDL. |
Name | Name of the parameter in the RDL. |
Required | Implies that the attribute name and is not mandatory. |
DisplayName | Displays name in the user interface for the check box parameter |
spParamName | Name of the hard coded text which returns values for the parameter in the RDL |
Select | = 0 for the first checkbox to be checked |
Commandtext value | Name of the stored procedure for the parameter in the RDL |
When the report is uploaded, the spParamName is bound to the parameter Commandtext to retrieve database values for the check boxes in the report.