Simple Report Has Duplicated Rows

[kc27]

Hello All

My simple report lists all the values entered for a single field in the database. The report is just a listing of the values, with one value on each row.

I used the Format Editor > common tab > "Suppress if Duplicated" check box on this field to only get one instance of any of the values, but it had no effect - the report still lists all the values once, whether the value is a repeat of one earlier in the report or not.

What do I have to do to ensure each row is a unique value, and not a repeat of a previous row?

Thanks in advance for any ideas on this.

 

[fisheromacse]

is the field sorted?

 

[Sahubba]

Do you have any groups?

 

[kc27]

I should have mentioned that I am using Crystal Reports 9.

No, I did not sort the field. If I do a sort, I still have duplicate rows.

I did try grouping the fields. That might shorten the list if if I can eliminate the rows that appear under each grouping. When I group, I still have all the duplicated rows, but now each one has a group heading. Is there a way to keep the group description row and get rid of the "data" rows?

 

[Turkbear]

Hi,
Just group on that 1 field and do not place anything in the details - you can even suppress the detail section entirely.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kc27]

Thanks everyone. I got it down to just the groups themselves. with the detail section deleted, I've got a lot of gaps between each grouping line. Is there a way to eliminate the empty space between the groups.

 

[fisheromacse]

If you sort and you still have duplicate rows, then they are likely not duplicate, but contain an additional record where the value you are looking at the same but some other field value associated with that record is different.

I think Turkbear likely gave you the easiest solution.

Another way i think you could go, is to suppress the details using the 'x+1' button next to the suppress checkbox and enter in: not(onfirstrecord); PREVIOUS({table.field})={table.field};

 

[Turkbear]

Hi,
Supress the Detail and Group Footer sections, that should eliminate the gaps.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kc27]

Thanks for the help everyone, I used Turkbear's solution of supressing the Detail and Group Footer sections to clean up the report.