I do all the development including custom SSRS reports on a development machine. In my reports I define the URL and credentials. The problem I am having is that each time I want to deploy my solution to the production environment I have to go to each report,
adjust the URL and credentials for the data source and then upload the rdl file with that change. There must be a better way to do this. Any advice is appreciated.
When you create a report in CRM with an RDL file, it replaces the SSRS data source with CRM's local database connection. If you export and re-import the report via a solution, the data source is updated automatically.