Reports with different DSN on Crystal Server

[Former Member]

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

[former_member198519]

Have you also created the same ODBC dsn on the Crystal Server as well. Remember you need to create a 32 bit ODBC DSN (system DSN) located under C:\Windows\Syswow64\ODBCad32.exe.

If you are connecting to SQL Server then in the database configuration of the report, define the database credential under Custom database configuration and also remember to define the Table prefix for the connection as well.

[Former Member]

Hi Kuldeep,

Thank you for helping!

sorry for not being clear, the ODBC DSNs I have created are on Crystal Server, and yes, it is from the location you gave.

I just tried as you suggested - checked and set 'specify a custom table prefix', but no luck....

Thanks

[former_member198519]

Can you update the database configuration in the original database details  and then try.

Do you have a single node or a cluster environment? if it is a cluster you need to have the ODBC connection on both the machines

[DellSC]

Kuldeep, FYI, CRS is single-server and cannot be clustered.

Does the report that's not working have more than one connection to a database?  Does it have any subreports? (each subreport has it's own connection).  If so, on the Database Configuration screen, there is a drop-down at the top called "Data Sources".  Make sure you have set the credentials for ALL of the connections in that list.

-Dell