Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Question on datasources

0 views
Skip to first unread message

kodaksmile

unread,
Dec 8, 2009, 4:46:57 PM12/8/09
to
Hi,

I am relatively new to SSRS and have a quick question - SQL 2005 sp2
comes with some free reports called Performance Dashboard. I have
successfully published these in SSRS but, would like to be able to
select the server I want to run it against rather than having one set
of reports for each server. Is there a way to have the data source
prompt for the server?

Thanks,

Bruce L-C [MVP]

unread,
Dec 9, 2009, 1:07:08 PM12/9/09
to
you can have an expression based data source but it is per report, not a
shared data source.

Then you need to have a parameter that you select from that specifies the
server.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"kodaksmile" <laura...@gmail.com> wrote in message
news:20c73b66-334e-4c8e...@z41g2000yqz.googlegroups.com...

Kiwi_smith

unread,
Dec 16, 2009, 7:07:02 PM12/16/09
to
I have done this for my reports by doing the following:

Create a parameter for server name and/or database name

Edit your data source and use the following expression in the connection
string:
="Data Source= " & Parameters!Server.Value & "; Initial Catalog="
&Parameters!DB.Value.

You will not be able to use a shared data source if you do this


"kodaksmile" wrote:

> .
>

0 new messages