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.
1 Like
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.
2 Likes
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