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

Crystal Reports Server 2011

I have been working with Crystal Reports 2011 and have created many reports. Some reports have parameters (for example date range). I am using MS SQL server 2008. All the reports work fine on windows 2008 server and windows 7. However, we purchased crystal reports server 2011 and install it on MS server 2012 R2. I am trying to post the reports in the crystal reports server 2011 and all the reports with the parameters give me the following error.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Dec 10, 2014 at 08:42 PM

    Has the SQL Server Native Client 10 or 11 been installed on the server? Are you using OLE DB or ODBC connections? If it's ODBC, have you configured the appropriate ODBC connections on the server?

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2014 at 03:15 PM

    I am not using native client. I am using crystal reports 11 as a client and ODBC connection.

    It is working fine on windows 7 clients and MS server 2008 R2.

    Add a comment
    10|10000 characters needed characters exceeded

    • The "Native" client is not a native connection to Crystal. There are a number versions of the SQL Server database drivers. The plain "SQL Server" ODBC client that is automatically installed with Windows will not work correctly with Crystal and SQL Server 2008. You need to go to MSDN and search for "SQL Server Native Client 10", install that, and then create your ODBC connection based on that in order to get Crystal to connect to your database.

      -Dell

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 06:07 PM

    I installed the native client 10 as you suggested and created ODBC connection. But still having the same issue.

    Add a comment
    10|10000 characters needed characters exceeded

    • Ok, now that you have the correct driver installed, you need to go to the Business View Manager (BVM), which is where you manage the objects that are used to create dynamic prompts in Crystal. Unfortunately, the Data Connections in BVM include information about which db driver is used in the connection. So, all of them are pointing to the older version of the SQL Server client driver that isn't working. This is the pain-in-the-neck part of the process....

      1. Find each Data Connection (object name should end in "_DC".) For each, create a new connection using the new client that you've installed. This would be a good time to reorganize and create a single Data Connection for each database instead of having one for each prompt, which is what happens when dynamic prompts are created within Crystal instead of creating them in the BVM and then using them in Crystal.

      2. Find each Data Foundation (object name should end in "_DF"). Change the connection on the Data Foundation so that it points to the appropriate new Data Connection.

      3. Delete the old Data Connections as they will not be used again.

      -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.