Changing the Data Source of SSRS Report

Changing the Data Source of SSRS Report

  1. Browse to the uploaded report.
  2. Edit the report at report builder
  3. Expand the Data sources folder
  4. Delete the Datasource1 data connection
  5. Right click the Data sources folder and add a new data source
  6. Click browse and navigate to the DYNAMICSGP Connection  at the Data sources folder. Ensure the Data Source name is Data Source1
  7. Test Connection, click ok to complete the change.

Cheers!
Sanjay