One CR Report...Many Databases with Identical tables

[Ngolem]

Hi;

I have written many CR reports that have been launched from the Web using the WebComponent Server (version 8.0). There is no problems passing user parameters from the Webform to the CR in addition to their user names and Passwords.

However, I am soon to start a project where Web Component Server and reports are stored on a central server but there are 5 satelitte facilities...each with their own databases but the tables and fields within these tables are identical.

I have ODBC connections to each of these locations.

Is it possible to pass the database name/ODBC connection ...dynamically to a Crystal report from the Web form?..I know I can pass the UserID and Password.

If not, I think my only solution would be to have 5 identical reports, one for each facility and have the Web form select which report to run....but this becomes a maintenance/resource problem as there are over 50 reports to write.

Any thoughts/comments are welcome

 

[Ngolem]

I found the answer in the Crystal Knowledge base:

the answer is yes....but must use ASP Report Server

http://support.crystaldecisions.com/library/kbase/articles/c2007576.asp

jim