Hide Duplicates problem

[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

 

[Wayne Morgan]

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

 

[Chris]

It is just a descriptive field and shoudn't be grouped for this report.....

 

[Wayne Morgan]

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.