Because I’m lazy, does anyone know a good way to mass change a report folders contents to all have the same data source? I hate doing things manually and in this example, I hoping there is a more efficient way to do this when the report contains many sub reports. Thanks
Are these E10 custom reports. There is a shared datasource you can change and it will update all.
If you are on MSSQL 2016 or later you can use PowerShell:
If you are on MSSQL 2017 or later you get the REST Api with SSRS.
These are custom reports but after moving from one environment to another the datasource needed to be repaired on each sub report
Very cool I’ll check it out