SQLServerCentral / Discuss Content Posted by Bilal Khawaja / Article Discussions / Article Discussions by Author

Dynamic Connection Strings in Reporting Services 2005

Bilal Khawaja — Sat, 31 Mar 2007 09:03:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/bKhawaja/2945.asp

Dynamic Connection Strings for Dummies

jvansandt — Mon, 28 Nov 2011 06:59:18 GMT

I am trying to statically set the server and choose which database that I want to pull the reports from, is that possible? And if so, is it possible to choose which db's that I want to use and restrict the list to those?

Dynamic Datasource in SSRS 2005

grkanth81 — Wed, 17 Dec 2008 20:23:54 GMT

Hi Bilal,The article which you have posted on Dynamic Datasource has helped me in getting a good idea on how to do it..........I have done exactly what you have mentioned in the article......and after deploying, when I am viewing the report,its asking me to enter the server name and the database name....after entering the values, the report is generated......Is it possible to do this way:Lets say I am having 5-6 servers on my SQL SERVER and then there are around 7-8 databases under each server.....SO I want to see the report in dropdown values of server and database rather than entering values manuallyFor the server, I will just assign 5 Non-Queried values in the report parameters window......and now what I want is, when I select any value from server dropdown box, I need to get the respective databases present on that server.....Is this possible???If so Can you give any suggestions of How to do it????Thanks,