Skip to Content
0

Crystal Reports

Oct 26, 2017 at 08:47 PM

48

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Abhilash Kumar
Oct 27, 2017 at 06:38 AM
0

Hi Angela,

How do you 'join' the third table?

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 27, 2017 at 01:50 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Oct 27, 2017 at 06:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded