SSRS 2008 .. How to create drop down menu for different databases in same server

Question

Post reply

SSRS 2008 .. How to create drop down menu for different databases in same server

Ritesh_Dev

Ten Centuries

Points: 1299
More actions
November 18, 2011 at 9:39 am

#263157

Please help me in this....
There are few databases DB1,DB2,DB3,DB4,DB5....
each database has same tables T1,T2,T3.....Tn. (each table has same columns C1, C2, C3......Cn... but data in those tables are different)
Requirement: *query:* select C1, C2, C3 from T1 inner join T2 on T1.C4 = T2.C4
the query will be same for all databases.
1. First step is to create drop down menu for Databases DB1, DB2, DB3, DB4, DB5
Then select one or more databases after that the query should run for selected database or databeses.
---- What source should I select and how to create dataset for them.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Chrissy321 SSCoach Points: 15763 More actions · Answer 1

Read this thread.

http://stackoverflow.com/questions/3943823/sql-server-how-to-get-a-database-name-as-a-parameter-in-a-stored-procedure

>>First step is to create drop down menu for

You need some type of application/front-end to create drop down lists.

If you had an application the drop down list value could be passed as the parameter (particular database) to a stored procedure as the article details.

Good luck

Ritesh_Dev Ten Centuries Points: 1299 More actions · Answer 2

Thanks for reply.

There is no front end facility to create drop down menu. I have to do it only with SSRS tool and sql.

Please let me know if you have some idea to do by this.

Bipinkumar Yadav SSC-Addicted Points: 443 More actions · Answer 3

If all DB on same server then u can create data source with respect to any of DB but make sure to Specify DB Name along with Query like DB name.table.column

Chrissy321 SSCoach Points: 15763 More actions · Answer 4

I would consider SSRS to be a front-end/application. It allows the users to interact.

Read up on parameters:

http://msdn.microsoft.com/en-us/library/dd220464.aspx

Look at the dynamic data source bit here:

http://msdn.microsoft.com/en-us/library/ms156018.aspx

This also looks promising:

http://www.gethynellis.com/2011/07/ssrs-dynamic-data-sources.html

Also see the Expression-based Connection Strings section here:

http://msdn.microsoft.com/en-us/library/ms156450.aspx#Expressions

...or google 'ssrs dynamic data sources'

Ritesh_Dev Ten Centuries Points: 1299 More actions · Answer 5

Thanks BipinKumar and SSC Vetran

Thanks for those links. They are helpful.. M working on it . Hope I will find the solution

🙂