Repoint SSRS report to another datasource
Description of Issue
Change SSRS report's datasource
Context
Munis all versions
Self-hosted, On-Prem clients
Tyler-hosted, SaaS clients
SSRS reports
Cause
Need to switch the datasource of a SSRS report to another datasource
Resolution
Open SSRS Web Portal and navigate to folder where the report is located
Right click on the report to open context menu.
Select Manage to open Report Properties
In the left menu, select Data sources
By default, A shared data source option is selected
Click on the ellipses menu at the end of the current datasource in next line
In the pop-up window, choose the new datasource
Click Save
The report now uses the new datasource to connect to server and fetch data.
Additional Information