Dynamic Data Source

Hi All,
In my project there is separate database for each client.
Based on the client i need to connect to the corresponding database and use
that as the data source to generate Report.
Is it possible to have dynamic data source without deploying all the reports
with different ds for all the clients.
Kindly let me know how to proceed ...
looking forward to your replies
ThanksYou can use data source expression since it will be executed at run time.
e.g="data source=" &Parameters!ServerName.Value & ";initial
catalog=AdventureWorks, the same can be for catalog as well.
But for your problem, you cant allow the user to select the dat source in
the form of a drop down.
If I have understood correctly, you need, depending on the users the DB
should be selected automatically. you can write custom code through asp.net.
infact this will be pretty simple.
Amarnath
"Toby" wrote:
> Hi All,
> In my project there is separate database for each client.
> Based on the client i need to connect to the corresponding database and use
> that as the data source to generate Report.
> Is it possible to have dynamic data source without deploying all the reports
> with different ds for all the clients.
> Kindly let me know how to proceed ...
> looking forward to your replies
> Thanks
>