Duplicate Records

[cgilmore]

I teach Crystal Reports 9. Some of our reports will show a record more than once, so I group them and put my formulas in the group footer. One of my students asked why do you see more than one occurrence of a record in the details section. Is it because the same record pulls from the master table and from the child table so you're seeing one from each table?

 

[stormtrooper]

Your database that your data is from could be set up like so:

NAME EMP NO PHONE
John Doe 1234 123-4567
John Doe 1234 987-6543

Now if you put these fields into the detail section, they will indeed show up twice (as many times as in the database). But if you group by NAME or EMP NO then you would get one instance of each. This is providing you do not have NAME and EMP NO in the details.