I have a SQL table that is the data 1

[rschaeferhig]

I have a SQL table that is the datasource for a CR9 report. The report groups based on three fields, A, B and C and sums the values of fields D, E and F. I'm not interested in the detail so I put the Group Name fields for A, B and C as well as Running Totals that reset on change of A for each of D, E and F in the Group Footer for C. (I need to see the total for C at every value of B and A.) Problem is the values for A and B duplicate in droves down the page. I tried Suppress Duplicates in the section expert but that only suppresses the fields if A, B AND C are duplicates of the previous line which never happens when you suppress the detail.

So it looks like this:
[tt]
A B C D E F
Fred Green North 5 3 2
Fred Green South 3 4 12
Fred Green East 1 4 3
Fred Blue North etc, etc.[/tt]

When what I'm after is:

[tt]
A B C D E F
Fred Green North 5 3 2
South 3 4 12
East 1 4 3
Blue North etc, etc.[/tt]

I know I can accomplish something similar using the Group A and B headers, but that adds a lot of extra lines to the report which the customer doesn't want.

Any suggestions?

 

[lbass]

Select the A field {table.A} which is duplicating, and then go to format field->common->suppress->x+2 and enter:

{table.A} = previous({table.A})

Repeat for the B field. That should do it.

-LB

 

[rschaeferhig]

That did the trick!! Thanks.