Hide Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my report, under a header called Description (not the Detail), I'm trying
to hide repeated fields as in:

Invoice No: 1 >Description header
1. Item: Chair >
Color: Brown >> Detail header
Color: Yellow >>
Invoice No: 1
2. Item: Table
Color: Blue
Color: Green

What I want to achieve is this:

Invoice No: 1
1. Item: Chair
Color: Brown
Color: Yellow
2. Item: Table
Color: Blue
Color: Green

I have enabled Hide Duplicates for the Invoice No control but it still
displays. Does the Hide Duplicates only work for the Detail? Thanks.
ck
 
CK said:
In my report, under a header called Description (not the Detail), I'm trying
to hide repeated fields as in:

Invoice No: 1 >Description header
1. Item: Chair >
Color: Brown >> Detail header
Color: Yellow >>
Invoice No: 1
2. Item: Table
Color: Blue
Color: Green

What I want to achieve is this:

Invoice No: 1
1. Item: Chair
Color: Brown
Color: Yellow
2. Item: Table
Color: Blue
Color: Green

I have enabled Hide Duplicates for the Invoice No control but it still
displays. Does the Hide Duplicates only work for the Detail? Thanks.
Click to expand...


I don't think HideDuplicates is appropriate here. This
looks more like you need to use Sorting and Grouping (View
menu) to group on the Invoice No and place that text box in
the group header section.
 
Back
Top