Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

Same report, multiple "copies" (pointing to different datasources)

I'm new to SSRS- getting the hang of it...

I have:
-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?

Thanks

L
0
tickett
Asked:
tickett
1 Solution
 
sureshbabukrishCommented:
how are you accessing the report, via report manager or through an application. you can create the report and publish to the report manager, try to create a paramter which passes the server name and dbname , so that you can select it during the execution of the report. thru application also you can pass the server name and dbname to get particualr report data

set the datasource properlties dyanmically.

try this - http://www.sqlservercentral.com/articles/Development/2945/
0
 
tickettAuthor Commented:
Thanks. Shame can't do it how i wanted, but i should be able to use that method (as long as i can prevent users changing the parameters and accessing the other databases).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now