Doug, Technically I would think the max DBCALC is not resetting. It is simply giving you the last invoice number up to that point. The DBCALC for the sum however has to reset to 0 in order to give you only the amount for that page.
I still use the SUM OF variable instead of the DBCALC for situations you are describing. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: Sunday, March 17, 2013 6:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Can't reset DBCalc on page break (still) Started with a new report in 7.6 in case I'd hosed the one I was working on and kept it real simple. For each page of the report, I want to print the last invoice number on that page and the sum of invoice amounts on that page at the top of the page (in the page header). In this test report, there are no Repo Header or Footer sections and no Break Points. No variables are defined. For both DBCalcs: LookAhead checked, there are no ResetBreaks Report layout: Page Header, 2 objects: DBCalc (Maximum(InvNbr)) DBCalc(Sum(InvAmt)) Detail Line, 2 objects: InvNbr InvAmt Page Footer, 0 objects: There are about 25 detail lines per page. In both Report Preview in Report Designer and running the Print command from a command file: The DBCalc (Maximum(InvNbr)) give me the last (and highest) invoice number on each page, which is what I want. :) The DBCalc(Sum(InvAmt)) gives me a running cumulative total of the pages, not the sum of each page. :( Ctrl-B (Breaks), On Page Break, Reset Vars doesn't list any vars to reset, because they are DBCalcs. Right-Click on the DBCalc, ResetBreaks doesn't list any breaks. How can I print the sum of the invoices on each page? I'm looking for ideas or appropriate RRBYW examples. And why does one DBCalc work and the other doesn't - both are set up the same? Any clues to clear the blues? TIA Doug --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
