Custom Report Deployment

The Custom Report Deployment function lets you deploy custom reports and execute scripts related to these custom reports on the FASTER Web database.

Tip

To view the Custom Report Deployment page, click the Custom Report Deployment link.

To deploy custom reports

1.    Click the Setup module.

2.    In the Administration Setup section, do one of the following:

o      Click next to the Manage Data option, and then click Custom Report Deployment.

o      In the Manage Data section of Administration Setup, click the Custom Report Deployment link.

The Custom Report Deployment page opens.

  1. In the File Path section, preform the following to select scripts or reports or both as required:

Note: The scripts are executed in an ascending order. You must select the scripts in the order in which you want to execute them on the FASTER Web database.

  1. In the Report Server Credential section, provide the credentials of the user having deployment rights on the report server:

  1. In the Report Server Domain box, type the report server domain name.

  2. In the Report Server User and Report Server Password boxes, type the user name and password to connect to the report server, respectively.

Note:

  • The following report server roles have deployment rights on the report server:

  • Content Manager
  • Publisher
  • My Reports

  • FASTER Web fetches the value of Report Server URL and the name of the Report Sub Folder from the Web.config file and displays in the Application Configurations section.
  1. Click Proceed.

FASTER Web validates the specified information and checks whether the Custom Report folder exists inside the Report Sub folder. If the Custom Report folder does not exist, a folder is created as {Report Sub Folder}\ {Custom Report Folder}.

  1. Perform the following to select scripts or reports or both as required:

Note:

  • The Script Information section displays all the scripts that you have selected in the Stored Procedure (.sql) Files box, the name of the scripts and their execution order.

  • To clear the scripts selected, click the Reset button.

Note:

  • The Report Information section displays all the reports that you have selected in the Report (.rdl) Files box. If any report is already present in the Custom Report folder, the Overwrite Existing Report column displays the following two options:

  • Yes - Select Yes if you want to overrides the existing report server’s report with the selected report.

  • No - Select No if you do not want to override the report server’s report.

By default No is selected.

  • When the reports are not available in the Custom Report folder on the Report Server, the Overwrite Existing Report column displays N/A.

  • To clear the reports selected, click the Reset button.
  1. Click the Execute Scripts & Deploy Reports button to begin the script execution and report deployment process.

Note: To move to the previous page, click Back.

An execution summary result containing the scripts and reports that were executed or deployed successfully or with errors is displayed.

Note:

  • The execution summary displays the following details:

  • The Configuration Details section displays the details such as Database Server, Database Name, Report Server URL, and Custom Report Folder Path.

  • The Script Details section displays the list of scripts that were executed and their execution result.

  • The Report Details section displays the list of reports that were deployed and their deployment result

  • After the report deployment and the script execution is completed, the CustomReports.xml file on the report server is updated with the proper structure of reports to display the custom reports in FASTER Web.

  • To go back to Custom Report Deployment page, click the Go To Custom Report Configuration button.

 

Tip

To view the Custom Report Deployment Summary  page, click the Custom Report Deployment Summary link.

  

Top of Page