Note: These global variables are not truly global. In the On Print event of the Page Footer place the code to assign the global variables to the report variables, then clear out the global variables to prepare for the next page.īelow is an example of two pages of the output: In this example it is called gbl_subtot_invoice and gbl_subtot_gross.Īdd the code in the Detail_Print procedure to sum up the columns as each on prints on the page. In the on print event procedure put a global variable(s) after the ‘Option Compare Database’. Follow these steps:Ĭreate unbound fields in the Page Footer of the report for each subtotal you want to display.Ĭreate an On Print event procedure in the Detail section of the report. We’ve notice many of you searching for an example of how to display report page subtotals at the bottom of each page of the report. When I try to sum column in a report using expression -> sum ( outcome) it show error in the sum textbox. I want to sum column in a report and sum another column in a sub report and sum the result from the two columns in a label. Page Subtotals Access Reports Display Totals at Bottom of Each Page I have a report contain sub report on Microsoft Access database.
0 Comments
Leave a Reply. |