report summary total
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,
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,
This discussion has been closed.
Comments
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
http://www.digital-metaphors.com
info@digital-metaphors.com