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

CR10 problem with Memo field in subreport

I have a report that runs fine in CR11 and SQL server that contains a subreport that display a Memo field only. When I send the report to a customer that is running CR10 Developer on Oracle 10, the subreport when run with the main report will only display 2 character but if we save the subreport seperatly and run it, the memo field is displaye properly.

Note: I do not have Oracle on my system and the report will not run properly at the customer site when runned with the CR11 runtime also so I think the problem is somewhat related to Oracle 10.

Is there a know problem with Oracle, memo field and subreports?

What could be done to get the memo field to display properly?

Thanks, Dan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 06:00 PM

    Hi Dan,

    This behavior is due to the datatype which is different in Oracle and in SQL Server.

    The LONG datatype field in database is shown as MEMO datatype field in the Crystal Reports (CR).

    The issue mainly lies with the connection, when the DSN is created using the ODBC driver.

    ODBC driver do not support this field datatype and therefore shows the truncated data.

    1. Download the ODBC Drivers for Crystal from the link provided below.

    http://www.businessobjects.com/products/downloadcenter/crystalreportsxi.asp

    2. Choose the appropriate DataDirect ODBC Driver for the version of Crystal you are using.

    3. Install the driver and create a new DSN using the CR ODBC driver.

    Following are the steps to create the new DSN.

    a. Go to Start > Control Panel. Select Administrative tools > Data Sources (ODBC).

    b. Choose the System DSN Tab. Click Add button, and choose the CR Oracle ODBC Driver, and then click Finish.

    c. The ODBC Oracle Driver Setup window gets open. Fill in the details Data Source Name, Description, Server Name, and then click the u2018Test Connectu2019 button.

    d. The u2018Logon to Oracleu2019 window gets open and the Server Name gets selected automatically. Use the User Name and Password (they are the same that you use for the database login.).

    e. Click OK and then click Apply and OK on the u2018ODBC Oracle Driver Setupu2019 Window.

    f. Open the Crystal Reports and while creating the connection choose the DSN that you have created using the CR Oracle ODBC Driver.

    g. Choose one of the Memo datatype fields in the report and the reports will display the data correctly.

    Hope this resolves your issue.

    Regards,

    Abhijeet T

    Add a comment
    10|10000 characters needed characters exceeded

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.