Changing the Data Source of SSRS Report
- Browse to the uploaded report.
- Edit the report at report builder
- Expand the Data sources folder
- Delete the Datasource1 data connection
- Right click the Data sources folder and add a new data source
- Click browse and navigate to the DYNAMICSGP Connection at the Data sources folder. Ensure the Data Source name is Data Source1
- Test Connection, click ok to complete the change.