multiple customers on the same reporting server.

Hi,
I think this is a question for the specialists among us.
Can I use one general reporting server (installed on instance
MAINREPORTING)
for multiple customers who all have their own sql instance (CUST1,
CUST2, CUST3, ..)
I would user UserAuthenciation on the reportserver url to display the
reports specific customers
can use.
Is this possible, and what do i have to take care off concerning
installation and/or configuration (especially on
the reporting side).
Greetings
VinnieWhat you want to do is have your data source based on an expression. The
problem with this is that you have to design all your reports this way and
the data source cannot be a shared data source.
But, if you do design your reports this way you can have the expression be
based on the user (global variable User!UserID).
You would need a table somewhere mapping a user to a database, query that
table and use the result for the expression that the data source is based
on.
This all works only for RS 2005 (not RS 2000).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vinnie" <vsempoux@.gmail.com> wrote in message
news:7b3fec53-bb60-4ad9-b8d3-81d9021f1831@.e4g2000hsg.googlegroups.com...
> Hi,
> I think this is a question for the specialists among us.
> Can I use one general reporting server (installed on instance
> MAINREPORTING)
> for multiple customers who all have their own sql instance (CUST1,
> CUST2, CUST3, ..)
> I would user UserAuthenciation on the reportserver url to display the
> reports specific customers
> can use.
> Is this possible, and what do i have to take care off concerning
> installation and/or configuration (especially on
> the reporting side).
> Greetings
> Vinnie