Problem:

You have your SQL Server Reporting Services environment in native mode — and you want to modify the data source of a report there.

Solution:

1. Navigate to Report Manager.
2. Navigate to the Report that you want to Manage and run it
3. After the report renders, you will have a breadcrumb navigation on the top right
4. Click on the Last Part of the Breadcrumb Navigation
5. It should open up the “properties” section of this report
6. On the properties section, you should be able to manage the data source
   
7. Make the changes that you wanted to the data source settings of this SSRS report — and don’t forget to click “apply”
8. Done!

Author: Paras Doshi