Changing Datasource connections dynamically

[dipstm]

Hi All,

How can we change the datasource connections dynamically of reports?

For example, Let say I have 50 customers and each of them have there own database.So when the report runs it should dynamically  retrieve the data frm a particular database belonging to  a  client.

Regards,
dipstm

[Ty Clabbers]

I presume that user A always should go to database 1, user b always to database 2 etc. In that case you can make several connections within a single datasource to your different databases. You can then give acces right per connection to the different users. If one user has rights to more then one connection he will be prompted to choose wich connection to use at runetime.

[dipstm]

Hi,
Thanx for your reply.
Can you please suggest how should I go about to implement the same.Also I dont want the prompt to appear bcoz one user will have access to one database only.

[Ty Clabbers]

I don't understand your question. You just should go to the connections of a datasource (tools/directory/datasources and click the link to the datasource). There you can make extra connections. Then you can set the permissions of those extra connections (properties/permissions tab).
If you don't want your users to choose between connections just be sure that every user only has access to only one connection.