is it possible for CR XI to select a database source based on a report parameter?  I have one report that serves two different libraries, both on a same server.  I have two parameters: lib1, lib2. So when user select lib1, I wish the report will point to DB sourceX; if user select lib2, the report will point to DB sourceY.  could anyone please advise if this is  achievable?

Thanks in advance.

 

John

 

Well, I'll take a step back, it depends on how the data is delivered to the report.  If you have separate users and you bind to the data via odbc, you could set each user's odbc connection to a different datasource.  If you have 1 user, they would need to change the odbc setting.  If you pass the datasource to the report (ADO.net, XML file) then you control the datasource and not Crystal.

 

But if you want to pass a parameter to change the datasource, the answer, I am fairly sure, is NO.

 

As stated above, there are ways around this.

 

HTH