Consolidate results?

BITS

Hi,

I'm following on from a report designed by someone else which is currently in use and working. I've had a request to modfy it slightly. I want to consolidate some results to stop repeated columns.

Title1 Title2 Title3
001 abc 1
002 bcs 1
001 gdg 3
001 dfd 3
003 dfd 3
004 fff 4
004 fff 2

At the moment, results are given as above.
The client has asked if the results could be given so they appear once (Title1) and the figures in (Title3) be added together. Deleting Title2..

To appear as below

Title1 Title3
001 7
002 1
003 3
004 6

I can't use a query as they are not part of my FR build so I need to do the above using subreport or code although im no espert with pascal.

Thanks for any help

gordk

probably want to use a crosstab to create a summary.

BITS

I've never used a crosstab report but will look to the manual now.

Would a cross tab report be able to determine duplicate 'TITLE1' entries and then add the 'TITLE2' entries together so I have 1 row for each individual 'title1'?

Thanks

BITS

That's what I currently have..

I want the duplicate 'COST CENTERS' put together and their results added together.. USERs column will be deleted...

I can't use a query, I can't change the database. I have to do it within the report using grouping or a cross tab as suggested above which im about to read into..

Thanks