Keith The only thing I notice that looks at all off is:
> H1 Category and Name (evaluated in Detail section for Break 1) > H2 Account Name ( " " " " for Break 2) If these are simply break headers, they should be evaluated in H1 and H2 respectively, not in D. I don't know if that will affect your summing issues, but it's worth a try! David Blocker ----- Original Message ----- From: "Keith Jacks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 20, 2002 6:36 PM Subject: Re: RBDOS Report Break Summing > "A. Razzak Memon" wrote: > > > Keith: > > > > Make sure to check the "Section" defined for each > > expression under variables list, in report designer. > > > > Any section defined for variable(s) must match the > > location of such variable in report. > > > > Good Luck! > > > > Very Best Regards, > > > > Razzak. > > 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/ ================================================ 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/
