Way to select data source

[kodaksmile]

Hi,

I am relatively new to SSRS and have a question - I deployed the Performance Dashboard reports (post sp2 on sql 2005) in my SSRS 2008 reporting services and they work well for 1 instance. I would like to let the user select the server they want to run the report against - is there a way to configure all of my servers as a data source and have the user select the data source at run time rather than have to create a report for each data source?

Thanks,

 

[xlbo]

the data source can be set as the result of an expression so you should be able to create a report parameter that asks for the server they wish to run against and use that to define the connection string...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[kodaksmile]

That sounds good but, how do I do that?

 

[kodaksmile]

Ok I did get a little further - I got the main report to work and accept the server information by modifying the data source as follows:

="Data Source=" & Parameters!ServerName.Value & ";Initial
Catalog=MSDB"

My next challenge is that there are several sub reports that had used a shared data source before. I tried making the same change on those however since they normally do not prompt the user and all data is normally passed in I think I may need yet another piece. Suggestions?

 

[xlbo]

You have a parameter on the main report that tells you which data source to go to

Create a parameter on teh sub report that does the same and pass the parameter from the main report to the subreport....

Param value on subreport:

=Parameters!ParamName.value

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question