Prev: SSRS 2008 and Custom URL
Next: Report Parameters problems
From: kodaksmile on 8 Dec 2009 16:46
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,

From: Bruce L-C [MVP] on 9 Dec 2009 13:07
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.grob(a)gmail.com> wrote in message
news:20c73b66-334e-4c8e-8b96-8e7f6925fc53(a)z41g2000yqz.googlegroups.com...
> 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,
>
From: Kiwi_smith on 16 Dec 2009 19:07
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:

> 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,
>
> .
>
 | 
Pages: 1
Prev: SSRS 2008 and Custom URL
Next: Report Parameters problems