Linking Multiple Tables

Posted on 2006-05-15
Last Modified: 2012-06-27

Crystal Reports 11
I have 3 tables

1st table (Orders) has
Order Number, Customer Number, Employee Number, etc.

2nd Table (Employees) has
Employee Number, Name, Address, etc.

3rd Table (Customers) has
Customer Number, Name, Address, etc.

From Databse Expert, I link the (Orders) Customer Number to (Customers) Customer Number and display the Customer name on the Report

I link the (Orders) Employee Number to (Employees) Employee Number and display the Employee name on the Report.

The report will work fine if i only use only 1 of the 2 fields, Employee Name and Customer Name, but will not display both at the same time.

I get error msg. Failed To Retrieve data from Database. Details: 42000:[SoftVelocity Inc][TopSpeed ODBC Driver][Expected lexical element not found: <identifier> [Database Vendor Code: 10015 ]

P.S. I see that the Customer Number from the (Customers) is indexed with a red flag, also the Employee Number (Employees) is also indexed with a red flag.

Question by:repco
    LVL 77

    Expert Comment


    Author Comment

    Hi, Thanks for the quick reply but unfortunatly, the Software that is listed there is for Crystal Report 7 and i use CR11. I cannot find that registry key no where.
    LVL 77

    Accepted Solution

    OK Try this one then - it is V10 but I guess it would apply to 11


    Author Comment

    Hi Pete,

    Ok i followed the instructions. The only thing that does not explain well in these instructions is in Step #5

    5. Add the correct join syntax for your database. Refer to the required information from step 1.

    In their example below that, where it completed the final txt file, no where in those lines have OJSyntax stated there.

    Example of the TXT file for the registry key update:

    Windows Registry Editor Version 5.00
    [HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]

    Where would i put my StarEqual? Or do i have to? I tried just doing it the way the example did it without putting the StarEqual and it still did not work.

    LVL 100

    Expert Comment

    What kind of link did you use?

    Can you show the SQL?

    LVL 77

    Expert Comment


    I can see your problem with the instructions.
    It is not clear whether you include the line
    or not.

    I suppose you will have to try both, but I would guess that it is the instruction which is correct and the given example which is wrong.

    You will need a different key for CR11.

    Based on my machine, the key appears to be:
    [HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Database\QueryBuilder\JoinBuilder]

    but check this on your own machine first.

    Obviously you edit the registry at your risk.



    Author Comment

    I contacted softvelocity and they did not have an direct answer for me but told me to at least try these 5 entries sent by email. Out of the 5 i tried

    [HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]

    As you can see the Crystal Reports documentation states to use StarEqual and not StarEqualJoinBuilder. Apparently the StarEqualJoinBuilder worked!

    Thanks very much for your help!!
    LVL 77

    Expert Comment

    Well done.


    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now