Crystal Reports - Calculate Sum
-
I have a crystal report that displays records from a database.Each record has a number field "QTY". I want to display at the end of each page the sum of this field for all records in this page... ,and in the last page i want to display the sum for the page and the sum for all records in report. Thank you
-
I have a crystal report that displays records from a database.Each record has a number field "QTY". I want to display at the end of each page the sum of this field for all records in this page... ,and in the last page i want to display the sum for the page and the sum for all records in report. Thank you
-
Check out the Running Total Fields in the field explorer while editing your Crystal Report.
-
thank you i used the running total fields , but with this i can create a sum field for all records .I want to create a sum field for each page .for example : Page 1 : QTY 5 6 7 Sum 18 Page 2 3 5 2 Sum 10 Report Footer Total Sum 28
Maybe these articles will help: http://www.frankkerrigan.com/2007/02/16/crystal_reports_page_totals~1750561[^] http://www.mcse.ms/archive/index.php/t-1014722.html[^]