August 7, 2014 at 8:28 pm
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!
August 7, 2014 at 8:46 pm
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/
August 8, 2014 at 4:38 pm
pietlinden (8/7/2014)
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/%5B/quote%5D
Thank you for the quick reply! I was searching for the wrong thing. I'll try it out next week.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply