What stops records returning? 3

[AyJayEL]

I have a report with lots of tables in it. Every table is linked using an outer link. Yet, when I run it if a person doesn't have an address logged in the database it won't bring them back in the report. What else could stop the record being returned in the database apart from the table linking?

Learn something new every day
Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80

 

[Madawc]

When you say 'outer', does this mean 'left outer'? Or does Crystal 8 not include the choice?

Have you done a selection on the address? When you have an outer link A to B, but also select for B, it will reject all type A with no linked B.

If this is the case you'll have to remove the selection, handle it some other way.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[AyJayEL]

Hi Madawc, thank you for answering my query. Yes 8 specifies Left Outers and that's what they are. And no there is no selection on address.

Any other ideas?

Learn something new every day
Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80

 

[Madawc]

One of your other links? Try doing an experimental version, removing things until it starts returning the records you expect.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[AyJayEL]

All the other links are left outers. I'll try your suggestion.

Learn something new every day
Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80

 

[lbass]

If you have ANY selection on tables to the right of a left join, the left join will be, in effect, undone.

-LB

 

[synapsevampire]

Try commenting out everything in the Report->Selection formula->Record

That should return data, then start uncommenting one by one until you find the offending issue, and if need be, post the record selection and your findings.

-k

 

[AyJayEL]

Thank you folks. I had tables linked like this;- Student<->CorrespondenceAddr<->Catchment<->CatchmentSchool and I found a field for the CatchmentSchool Name (I didn't write this report).

I added in an alias for CorrespondenceAddr and used that for the child's address and that worked.

The registered base was a parameter in the selection. So I've sorted that one too.

Have a star each. Thanks again.

Learn something new every day
Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80