aaron.reese (5/26/2016)
How do others do source code control for reports. Do you have one project that contains all the reports one project per report / report area, or do you just source code control the .rdl files?
We use one project for all reports related to a specific database and lock that up in our source control. We don't have a lot of cross-database reporting so this method works fine for us.
The only problem that we consistently run into is that we use SQL authentication for the DataSources and our source control (not sure if it's universal) will clear out the password in the project. This caused a number of issues deploying "quick changes" until we found the setting that prevented DataSources from being overwritten on the report server.