I'm new to SSRS- getting the hang of it...
-created a bunch of folders for different departments (and assigned the relevant ad group permissions for that department)
-created a shared datasource in each of these folders pointing to the relevant sql server/db
-loaded the same report into each folder and tied the report to the relevant datasource
This is all very well but when i amend the report i have to update every folder. Is there a way for me to have one physical report published multiple times with different datasources?
I can see "Create Linked Report" but by the looks of things that only allows me to change parameters and not datasource?