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

Upgrading Reports originally designed in 8.5 to v11 and getting duplicate e

Good Day fellow Report Writers!

I am new to the Forum, so please excuse any Faux pas that I may be committing!

I have been writing reports in Crystal 8.5 for approximately 4 years to integrate into a Business Intelligence product at my company in the Financial Sector. These reports are usually against multiple Database tables, linked by 3 common fields by an inner Join. My company recently upgraded thier Business Intelligence product to use Crystal Reports Viewer 11, so I have to update my existing reports by opening them in version 11, refreshing database and saving the new copy. I am testing these reports in the actual crystal product before attempting in my company's application.

I have run into a problem however with the Inner Join across 2 or more Database tables. I am linking by the 3 common fields:

Key_Date

Key_Time

Key_Milsec

The first table is a Current Status table, containing only one line of history per unique combination of the 3 fields.

The second table is a Current Data Table, containing only one line per unique combination of the 3 fields.

This report is fairly simple. I am displaying a single line of data on the output which is a combination of data fields from both tables. However, When Crystal executes the SQL against the Iseries Access ODBC Driver record there are upwards of 50 lines of data returned for each unique combination of the 3 fields, even thought there is only one line in each of the database tables.

When I open the database expert and go to the link tab I get a prompt stating "Your current link configuration contains multiple starting points. Please be advised that this is generally not supported."

I have attempted all of the link options within the Database Expert, and the data does not change at all....

I admit that i am not the most savvy user of this application, but do not feel as if I am doing everything correct. I am able to run this exact same report in Crystal 8.5 with no problems, and I have taken the SQL and run it in other programs and the correct data is returned.

Any assistance would be appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 13, 2009 at 10:52 PM

    The error message you mentioned usually comes when tables are unlinked. Unlinked tables create Cartesian join when every row of one table linked to every row of another table. That explains why you have so many records returned.

    The simple solution would be to copy your SQL to Command object connection and CR will execute it as any other application.

    If you want to fix table links, then I would suggest to try solution mentioned in the following document:

    How to resolve join syntax errors in Crystal Reports 9 and later

    [https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c027d475-241f-2b10-24b9-ac3b51e417a3]

    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.