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.