Before on-premise clients can run reports in Report Gateway, a system administrator must deploy the data source and MRI data set, and import the MRI default report package. These tasks may also be required for periodic maintenance of Report Gateway.
Note
To upload a non-MRI (client-specific) report package, use the Upload Package option on the Reports page.
Use this option to perform the initial deployment of the Report Gateway data source and MRI shared data set to the SSRS server.
You may choose to use the default connection for the web site using the database credentials and connection string from the Platforms and Data Sources page, or to use an alternative connection string. The permissions for the alternative connection string user can be read-only.
Report Gateway does allow authentication using Windows integrated security, but ensure that your network and SSRS server allow the use of integrated security before you deploy.
To deploy a data source and data set, follow these steps:
1. Go to Admin Settings > Deployment.
2. To use a different connection string than the one configured on the Platforms and Data Sources page, enter it in the Optional Alternative Connection String field.
Note
Use one of the following formats:
Data Source=[server];Initial Catalog=[database];User ID=[username];Password=[password]
or
Data Source=[server];Initial Catalog=[database];Integrated Security=true
3. Select Uses a Windows Account if either the default Report Gateway connection string or the alternate connection string uses a Windows account. Otherwise, leave this option cleared if using a SQL Server user account.
4. Click Deploy Data Source and Data Set.
Use this option to upload and deploy an MRI report package in .zip format. Existing MRI reports are updated, and any new reports are added.
To import a report package, follow these steps:
1. Go to Admin Settings > Deployment.
2. Click Browse... and navigate to the MRI report package .zip file.
3. Click Import Reports.
If all reports were imported, a success message displays. If the import was unsuccessful, a failure message displays and indicates whether each report in the package was properly imported. Failures are also recorded in the issue log.
Use this option to redeploy the MRI data set only. You may occasionally be instructed do this when MRI Software makes a change to the data set required for reports to get connection information. After redeploying the data set, you must process and redeploy all reports as well.
To redeploy a data set, follow these steps:
1. Go to Admin Settings > Deployment.
2. Click Redeploy Data Set.
3. After the data set is successfully redeployed, click Process and Redeploy All Reports.
Use this option to redeploy all currently-deployed client-specific and MRI standard reports to the SSRS server without updating their metadata, such as report descriptions and tags. This may be required if your SSRS server fails and you need to redeploy and overwrite the existing reports on the server.
To redeploy all reports, follow these steps:
1. Go to Admin Settings > Deployment.
2. Click Redeploy All Reports.
If all reports were redeployed, a success message displays. If the redeploy was unsuccessful, a failure message displays and indicates whether each report in the package was properly redeployed. Failures are also recorded in the issue log.
Use this option to process all currently-deployed client-specific and MRI standard reports and redeploy them to the SSRS server. This option will also update the metadata for these reports, such as report descriptions and tags. You may occasionally be instructed do this when MRI Software makes a change to Report Gateway.
To process and redeploy all reports, follow these steps:
1. Go to Admin Settings > Deployment.
2. Click Process and Redeploy All Reports.
If all reports were processed and redeployed, a success message displays. If the process or redeploy was unsuccessful, a failure message displays and indicates whether each report in the package was properly processed and redeployed. Failures are also recorded in the issue log.