-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?
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.