Why does blank rows print?

[Jeanette]

I created a report where I set hide duplicate to yes for all fields in the detail section. The problem is that for those groups where there is duplicate info blank rows are printing. I do not want the blank rows to print for groups of data that have duplicating data. Is there someway to fix this? Thanks in advance.

 

[WayneRyan]

Jeanette,

Need more info. The hide duplicates is really only meant to be
applied to just a few fields. If you really don't want them in
your report, you can do a couple of things.

If you select DistinctRow, that is what you will get, but they will
not be in the report at all (possibly bad for totals, etc.).

If you use a Group By clause in a query, you can reduce them
to one row and have accurate totals in your report.

Wayne