I have 2 crystal report template which are the same except for the DSN name being used as data source. Both reports work in Crystal Report Designer - no error from the preview view. The problem comes when I try to run them from the BI launcher on Crystal Server. Only one of the report runs, the other one gives an error of "fail to open connection".
Things I have done to get what I see right now:
1. set up both DSN's in 32-bit ODBC
This seems to worked, because both templates are able to run in the Designer
2. upload the both report templates to Crystal Server through Central Management Console
3. In Central Management Console, right click on the file name, then go to "Database Configuration", set 'when viewing and scheduling report' to 'use same database logon as when report is run', then entered passwords. This step is done on both reports.
Could someone let me know if I am missing steps? I really need two different reports connect to different DBs accessible from the same BI launch pad. Any tip is appreciated.Thanks in advance.
Best,
Ting