Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

report summary total

edited January 2002 in General
Hi,
I have a report layout as follow:
Department employee salary
001 100 $10,000.00
001 101 $15,000.00
total department 001 $25,000.00

002 200 $30,000.00
002 201 $35,000.00
total department 002 $65,000.00

Question:
Is it possible to print all the department total at the end of the report?
001 $25,000.00
002 $65,000.00

Thanks for the help.
Vinh,

Comments

  • edited January 2002
    Stick them in a stringlist (or maybe use a couple of lists), as the report
    prints the totals. Then in the summary band, create a subreport and use a
    JITPipeline to read the data from the list into the subreport.

    Another approach would be to create a separate query which would perform the
    summary calculation into a calculated field. You could hook the summary
    subreport up to that data pipeline.

    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.