Skip to Content
avatar image
Former Member

Crystal Reports

I am working on a report with 3 tables from my database. When I enter fields from the first two tables, everything is fine. When I add a field from the 3rd table, all of the rest of the data disappears.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 27, 2017 at 06:38 AM

    Hi Angela,

    How do you 'join' the third table?

    Try changing the Join type to 'Left Outer Join'.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2017 at 01:50 PM

    Hi Abhilash,. It just tried and now when I pull the field over the other fields do not disappear, but the data for the field I pull over is now blank.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2017 at 06:34 PM

    Does the table have any data?

    Does it have any rows for the field you've joined on?

    An easy way to verify this is to look-up data in the table using a value from the field you've joined on.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded