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

Dynamic Datasource in SSRS 2005 Expand / Collapse
Author
Message
Posted Wednesday, December 17, 2008 8:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 31, 2014 5:14 PM
Points: 55, Visits: 471
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 manually
For 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,
Post #621752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse