Crystal Report Linking where link may contain nulls

Posted on 2011-10-06
Last Modified: 2012-06-27
Hi All

I have a situation where I have 3 datasources in the database expert.
There is a main table which contains a complete list of data that I want ( Ive checked the query, the total number of records agree with the front end and there is no duplicates )

I have two descriptions fields which are contained in two other command query datasources.
I linked them in the database expert but it ends up excluding 425 records because there are nulls in the main table.

How do I handle these nulls? I just want no field description to come through if there isnt one... not to exclude the record entirely....

Question by:StratfrordDC
    LVL 100

    Accepted Solution

    Change the joins to LEFT OUTER

    In the linking expert
    Right click one of the join lines
    Choose LEFT OUTER

    Left Outer Join
    TableA Left Outer Join TableB
    Select all records from TableA and the matching records from TableB

    By default joins are INNER
    TableA INNER Join TableB
    Select all records from TableA that have a matching record in TableB


    Author Closing Comment

    Excellent. Just what I needed.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    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…
    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…
    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.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    758 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

    11 Experts available now in Live!

    Get 1:1 Help Now