View Full Version : Grouping By: Does not bring linked field in reportl


wan2fly99
03-08-2007, 02:59 AM
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
03-20-2007, 09:10 PM
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
03-21-2007, 03:25 AM
Are you sure you haven't just slipped the Group Header into the Report Header by accident?