Newbie - Eliminate Duplicate GroupField

[Andyamstrad]

Can anyone help??

Have a report with the following Columns:

Product Total ComplaintType Total Name

ABC 5 Other 3 fred1
fred2
fred3

ABC 5 Poor Customer Service 2 john1
john2

EFG 1 Poor Customer Service 1 dave

The report is grouped on product then complaint type.

It should display :

Product Total ComplaintType Total Name

ABC 5 Other 3 fred1
fred2
fred3

Poor Customer Service 2 john1
john2

EFG 1 Poor Customer Service 1 dave

How can this be done, via a formulae???

Many thanks in advance.

 

[Ngolem]

you could place the following formula in the "conditional suppress" for the field displaying "Product"

Not PreviousIsNull({Table.Product}) and previous({Table.product}) = {Table.Product}

that should do it

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[lbass]

It looks to me like you have the groupname for the Product group dragged into the group header for complaint type. Instead of doing this, display the Product group name in Group Header #1 along with the group summary, and then go to the section expert->GH#1 and check "Underlay Following Sections."

I'm not sure why the GH#1 summary (5) is appearing in the second group #2 instance though--is this an inserted summary or a running total? It looks like an inserted summary would work and it would avoid the duplication.

-LB