December 5, 2024 at 12:32 pm
I have a one database and one table in that database. This is on 100 servers.
Same db and table name
1.Can I build a report which will change server connection based on the server selected in a drop down list of 100 servers.
Can the select data from multiple servers based on a check box list of 100 servers ?
2.Like if I select 10 servers I need data from 10 servers in the report.
Thanks
December 5, 2024 at 3:38 pm
Sounds like a hideous design.
Why not just put all the data in the same database with a foreign key column to the server name? Then you don't need any dynamic SQL or anything even remotely complicated.
"I'm [not] Kent Brockman, [but] that's My Two Cents"
December 5, 2024 at 5:34 pm
Thank you. But I already know that way. Trying to see if I can avoid centralizing the data into 1 server. No good reason for this.
But wanted to know if it can be done the way I am currently looking for
December 5, 2024 at 7:26 pm
You could use a parameter to let user choose server, & programmatically derive the connection string & dataset. See links below
Or -- not recommended -- you could embed all 100 connections & datasets in the report & choose the correct ones using selected parameter.
https://stackoverflow.com/questions/19827625/ssrs-report-dynamic-connection-string-and-parameters
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy