One technique I have used, for speed rather than accuracy, is to use SQL to get the totals based on the criteria for the break point. Using this technique the variable is evaluated only the once. The sum can also be in the header when this technique is used.
vF1Total = (SUM(column)) IN source table WHERE <breakpoint criteria> For example, using EmplNum and PayNum, break 2 could be something like vEmplPayTotal = (SUM(GrossPay)) IN Payroll WHERE EmplNum = EmplNum AND PayNum = PayNum Place this variable, and evaluate it only where it appears to avoid having it calculate on each row. eg F2 or H2 as required. Keith Jacks <[EMAIL PROTECTED]> wrote: >Hi Razzak, Anthony, Albert, & David, >Zero is set on. I have no variables reset at the page break. I had the >summing variables evaluated in the detail section since each row must be >included. I set the section to the F1, F2 and RF sections respectively, >but I get incorrect totals (i.e.; only the last detail row is added >in). The summing variables are identical standard reports type summers >as in SUM OF CHKAMT, just with 3 different names. The second level >break summer gets reset in its section, the first level in its section >and the RF summer never gets reset however it does not contain the >missing value either so it is incorrect also. The problem only occurs >under the very specific conditions of the break header on the bottom of >a page followed by a missed value in the detail section of the next >page. Other than this the other parts of the report print and total >correctly, and the problem moves to a different page if I change the >number of lines in a section. Maybe I'm missing something with the >section in which to reset, but this is the way I've summed report >variables for a long time in the detail section. I thought this was >necessary in order to evaluate every row into the summer. Is there >another way to get every row summed? The report runs off a 2 table >view. Lines per page are 59. Here is the layout of the report: >PH >PH >PH >PH >H1 Category and Name (evaluated in Detail section for Break 1) >H2 Account Name ( " " " " for Break 2) >D Description, check date, check number, check amount (Detail section) >F2 >F2 Total of check amount (Variable AMTSUM gets reset each account) >F1 >F1 Category total (Variable CATSUM gets reset each category) >F1 >F1 >F1 >RF Grand total (never reset) >RF > >Still stumped, >Keith Jacks >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
