How do I report on multi databases including tables with nill data?

Posted on 2006-05-16
Last Modified: 2006-11-18
Sorry I don't know the best way to describe this problem.

I need to report on multi databases but some of the tables will not have the information required to link...

Here an EXAMPLE to illustrate the problem:

The report is on FRUIT.

There is a "FRUITS" database of 4 Fruit Names with Fruit Codes: Apple:APL001 ,    Pear:PER001,     Banana:BAN001,     Orange:ORA001
And a "SEEDS" database of 3 Fruit with Seeds:  APL001:Seeds,    PER001:Seeds,   ORA001:Seeds

The Link between the databases will be on the FRUIT CODE.

I would like to report on Fruit showing Fruits Names and detailing if the Fruit have Seeds or not.

The desired result should look like:

Fruit Name          Has Seeds?
Apple                     Seeds
Banana                  [Blank]
Orange                  Seeds
Pear                      Seeds

Because there isn't a record of 'Bananas' or 'BAN001' in the SEEDS Database my report only shows the Fruit that do have seeds (or exist in the SEEDS database).

Fruit Name          Has Seeds?
Apple                     YES
Orange                  YES
Pear                      YES

How can I get Crystal Reports to show all values including blank records?

Question by:Mchallinor
    1 Comment
    LVL 77

    Accepted Solution

    Hi Mchallinor,
    When you have added the two tables to your report you will get the Links view displayed.
    In this view you need to double click the join-line and set it to a left outer join (from Fruits to seeds)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now