[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2006-05-16
Medium Priority
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

peter57r earned 1500 total points
ID: 16688923
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)


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Loops Section Overview
Suggested Courses

829 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