Grouping By: Does not bring linked field in reportl

[wan2fly99]

I have two databases: Sales and Customer

I do an outer join on Sales to Customer to select customer name

I group my report by sales-nbr. The group then should show the customer name for that sales-nbr

On the first one it does, but after the next groups of sales-nbr,
the customer names is not brought in. I checked the data to make sure the field is there.

I had the same problem in another report. I had to use the TRIM function to get rid of trailing blanks.
Tried it with this report and it does not work

This Crystal XI is driving me nuts

 

[boblarson]

What fields are you linking within both databases? The primary and foreign keys should be numeric, because text fields are not necessarily reliable as keys.

 

[Mile-O]

Are you sure you haven't just slipped the Group Header into the Report Header by accident?