Since this is a custom solution it requires a custom installation. The following steps will guide you thru setup and publishing of the customized reports to a SQL Reporting Services ConfigMgr Reporting point.
We are going to be using the ReportSync app. This is also a good to the have for capturing backups of your reports and was as synchronizing and moving report between SSRS report servers.
You can download ReportSync from here: https://code.google.com/archive/p/reportsync/.
Or from here:
Setup and install a new Reporting point and wait for the installation to complete.
Next, we will use ReportSync to configure and upload all customized reports to the SSRS report server.
Download ReportSync from here: https://code.google.com/archive/p/reportsync/.
After downloading ReportSync, you should find the executable “ReportSync.v1.1.2.exe” in the location where you downloaded the file.
Run the executable by double click “ReportSync.v1.1.2.exe”. You should see the following dialog screen shown below.
Enter the URL of your SQL Reporting Services report server portal, Example: “http://ServerName/ReportServer” in the URL field for both the Source SSRS web service and the Destination SSRS web service.
Enter the user or service account that has access to publish reports to your SSRS report server. Enter the users name and password in both area for the Source and Destination SSRS web service.
Next, create a folder on the C drive. Example: “C:ReportSync”.
Now, create a folder named “RicherReports” in the “C:ReportSync” folder.
You should now have “C:ReportSyncRicherReports”. Shown below.
Enter the path “C:ReportSync” into the Local path field shown below.
Now you need to create data sources that reports will connect to.
Click New int he Upper Right had corner of the SSRS report server portal. You should see the following view, and enter "Data Sources", then Click Create.
Now, create the data sources in this folder. Click on New in the upper right hand corner, then Click on Data Source.
You should see the following New data source view.
Populate the fields using similar values shown below; replace values to match your environment.
Click Test connection to validate credentials.
Confirm the connection test.
Click the Create button to create the data source.
You should now see the new data source, example shown below.
You just completed creating a data source for the ConfigMgr database.
- Data Source: “CMDB” = ConfigMgr Database
- SQL connection string: Data Source=SERVERNAME;Initial Catalog=CM_CFM
You now need to create data sources for the following database, and you will also find the configuration for each database below.
- Data Source: “MBRE” = MBAM Recovery Database
- SQL connection string: Data Source=SERVERNAME;Initial Catalog=”MBAM Recovery and Hardware”
- Data Source: “MBST” = MBAM Compliance Status database
- SQL connection string: Data Source=SERVERNAME;Initial Catalog=”MBAM Compliance Status”
The following SQL connection strings are for connecting to the where SQL Reporting Services is running.
- Data Source: “MSDB” = SQL Server System database
- SQL connection string: Data Source=SERVERNAME;Initial Catalog=msdb
- Data Source: RSDB
- SQL connection string: Data Source=SERVERNAME;Initial Catalog=ReportServer
Sync & Upload
Click Load for the Source SSRS Web service and allow it to complete.
Click Load for the Destination SSRS Web service and allow it to complete.
You should now see the ReportSync screen look similar to the following screen shot.
Now, extract the contents of your RicherReports Zip file to the “C:ReportSyncRicherReports” path.
You should now see additional RDL files in the “C:ReportSyncRicherReports” folder. Example shown below.
Now open IE and navigate to your report server. i.e. “http://SERVERNAME/Reports” You should see the addition RicherReports folder.
Now open IE and navigate to the following URL change SERVERNAME to your server name.
You should now see the RicherReports Portal. Example shown below.
You can now run the portal report by using the URL below. Change the SERVERNAME to the value of your SSRS server name.