RicherReports 2.0 Default Setup and Configuration

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.

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".

Enter the newly created folder name and path in the Local path field shown below. 

ClickLoad for the Source SSRS Web service and allow it to complete.

ClickLoad 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 go to your SSRS report server portal http://YourServer/Reports.

Now, notate the default ConfigMgr folder name; It's usually named something similar to "ConfigMgr_###". 

Where ### is the site code of your central site server. This could be anything depending on how is was configured it during setup.

Now, Go to the folder you created on the C: drive "C:\ReportSync".

Copy the downloaded RicherReports Zip file to the Report Sync folder "C:\ReportSync".

Note: Don't try to extract the contents from a network share. You may run into file names being too long that will fail the export. 

Next, Extract the RicherReports20.<SKU>.zip contents to the ReportSync folder we created on the C: drive "C:\ReportSync".

You should now have two additional folders in the ReportSync folder, "RicherReports" and "Default Reports".

Now rename the folder "Default Reports" to the same name as your ConfigMgr reports folder. i.e. "C:\ReportSync\ConfigMgr_P01_Reports".

Now, Click Upload in the ReportSync App.

When the upload process completes you will see the following completion dialog box.

Great! You know have RicherReports 2.0 Default ConfigMgr reports customized.

​The following are a couple before and after screen shots of the Compliance 1 - Overall compliance default report.

 Before RicherReports:

After RicherReports has been setup:

​Setup Complete. 

Now access any of your ConfigMgr default reports and enjoy RicherReports 2.0. 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.