reporting-servicesssrs-2016sqlreportingservice

SSRS-Datasource won't change when reupload report

I got a report with 2 data sources and both are Shared Data source. I am trying to change both of them to Custom Data Source but when I re-upload the report in my Report Manager, it won't work.

Edit: I don't have an error because the report successfully uploads, but the data source doesn't change. If I have a field in the report, the report shows the new field, but the data source stays the same.

Solution

  • This might be because of caching that SSRS does with the datasource for the report on the server. Do the new datasources have the same name as the old ones?

    You could create the custom datasources in the DataSources tab in the Manage menu for the report in the report manager.

    To do this open up the Report Menu by click on the "..." then selecting Manage

    Manage

    Then click on the Data Sources Tab, then change the data source to Custom Datasource.

    Data sources tab

    Then set up the datasource like you did in the report, you will need to select SQL Server for the Connection, add the connection string and choose the authentication type which in the image below is windows authentication but I am not sure how it is set up on your server. Then click Test Connection. Then Click Save (make sure you click Save before navigating away).

    Custom Datasource

    Or you could delete the old report in the report manager and then upload it again. Note that deleting the report will delete any schedules and other customization you have done ie. Name and Description.