Prerequisites

Before you add or upload the custom reports ensure that:

• The reports are tested.
• The user having the Content Manager role on the report server uploads report to the report server.
• If a report requires check box parameters, the user must provide a .zip file that contains the RDL file and the PCRReportParameters.xml file. The .xml file has parameters for the check boxes.
• The RDL files are not read-only files.
• The number of parameters used in the RDL file and the number of parameters passed to the final stored procedure match. The stored procedure returns the final dataset when a report is executed.
• The scripts, to create the database object for the reports, are saved in the SQL file. These scripts are validated by the user before they are uploaded to the SQL file. The SQL file helps to create the database objects for the report using these scripts.
• Report description text or the help text, if any, must not contain special characters - &, ‘, \, /, <, > and ?.

Invalid script generates error in the logs. An error message is displayed on the user interface.