Data disappears when adding a field

[wilekoyote76]

I have a connection to the Goldmine database with Contact1 and Contact2 selected for tables. Contact2 was where all my reports derived their data. When I add a field from Contact1 into the report, all the data disappears in the report.

Is there something programatically that I need to do or is this because I'm bringing in data from multiple tables?

 

[Madawc]

If there was no corresponding Contact1 record, that would explain it. You can fix this by a Left Outer link.

Note that Left Outer would fail if you also did a test on Contact1, Formulas stop if they hit a null, unless you do an IsNull test first.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[wilekoyote76]

It is currently set to Left Outer Joins

 

[lbass]

Does your record selection formula reference Contact1? If so, remove that criterion. Also you might try "not enforce" on the join.

-LB

 

[wilekoyote76]

selection formula so no reference to contact1

if {CONTACT2.UCLMNO} > 0 then
(isnull({CONTACT2.UDATEINV}) or {CONTACT2.UKEEPACT} = "Yes");

The data doesn't disappear now, but the contact1 field I'm trying to insert is "blank"

 

[lbass]

I think you will have to check how each field that you are linking on displays if you use only its own table. Either the field is not populated or the fields do not match.

-LB

 

[wilekoyote76]

browsing the data field, it is showing the data in there. Here is some of the linking that is happening

 

[wilekoyote76]

link legend to refer to

 

[wilekoyote76]

Final Linkings

 

[lbass]

I don't want to have to open a link for every little thing, and in fact, I just had to shut down because of one of these links. You should be able to briefly respond within the thread to relay the same kind of information.

I wasn't asking about your links or whether there was data in the fields. I was suggesting you need to run reports separately for each table, and check how the fields you want to link actually display to see if they really match.

-LB

 

[wilekoyote76]

Thanks for pointing me in the right direction. Recid was linked between the two and was causing the problem. Gotta love Goldmine choosing the links for you.