Grouping or sub-report?

BITS

Hi.

Just want to know what the recommended way of doing soemthing quite basic may be..

I have a table of data and below is how it is currently laid out in my finished report


COST CENTRE B/W PAGES B/W COST COLOUR PAGES ETC ETC

1 2 4 3
4 3 2 3


You get the idea.. Soemtimes, I have a duplicate COST CENTRE

COST CENTRE B/W PAGES B/W COST COLOUR PAGES ETC ETC

1 2 4 3
4 3 2 3
4 5 3 4

What i'd like is to consolidate the duplicate item so the above appears like this:

COST CENTRE B/W PAGES B/W COST COLOUR PAGES ETC ETC

1 2 4 3
4 8 5 7


I duno the best way of going about this through fast report?

thanks

Anu de Deus

sort out your SQL statement instead (if possible, in your case):

select A, Sum(B),Sum( c ), Sum(D)
from tableA
group by A

BITS

Unfortunetly not. I have to do all within FR, I can't touch the SQL or database which is a real pain!