Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report with multiple databases Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 8:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:20 AM
Points: 6, Visits: 18
Hi All,

I am still a newbie with SSRS, but I have 6 databases all with the same schema. Right now I know how to build individual reports for each site creating 6 reports with 6 a data sources assigned to each one.

Is there a way I could build a report that the end user could select from which database to pull the data from and could there be a option to pull all data in one consolidated report? Any help would greatly be appreciated.

Thanks!
Post #1601001
Posted Thursday, August 7, 2014 8:46 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:55 PM
Points: 812, Visits: 5,160
Welcome!,

Did a little digging around both on here and the internet and found a couple of really good examples showing how to do exactly what you are asking about.

Kathi Kellenberger's sitehttp://www.bidn.com/blogs/KathiKellenberger/sql-server/3082/configure-ssrs-to-use-a-dynamic-connection-string

http://skamie.wordpress.com/2010/12/17/ssrs-changing-data-source-dynamically/
Post #1601004
Posted Friday, August 8, 2014 4:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:20 AM
Points: 6, Visits: 18
pietlinden (8/7/2014)
Welcome!,

Did a little digging around both on here and the internet and found a couple of really good examples showing how to do exactly what you are asking about.

Kathi Kellenberger's sitehttp://www.bidn.com/blogs/KathiKellenberger/sql-server/3082/configure-ssrs-to-use-a-dynamic-connection-string

http://skamie.wordpress.com/2010/12/17/ssrs-changing-data-source-dynamically/



Thank you for the quick reply! I was searching for the wrong thing. I'll try it out next week.

Post #1601348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse