Skip to Content
author's profile photo Former Member
Former Member

Reports with different DSN on Crystal Server

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 26, 2016 at 07:45 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.