Hide Duplicates problem

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a report with multiple rows of data for each record. The hide
duplicates cleans up the report nicely, but if the field contains the same
data as the previous record it does not print the hidden data again and you
need to look to the previous record to tell what the data should be. Is
there a way to make it print the data once per record? It does print on a
page break which makes me wonder if there is a way to set when to print.

Thanks,
Chris
 
Could you group on the fields that have repeated data? If so, you would get
one "group header" for the repeated data then print the rest of the
associated records.

Example:

Instead of
Balls Baseball
blank Basketball
blank Football

You would get
Balls
Baseball
Basketball
Football
 
In that case, you could use a variable declared as Static in the detail
sections Format event to keep track of the value of the control/field. You
could reset the value of this variable with each new record. You'll need a
way of keeping track of whether or not you've changed records. How you do
that will depend on the reports setup. If the data in the field is the same
as the last entry in the current record, hide the control or set the font
color to be the same as the background color.
 
Back
Top