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
================================================
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)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
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.
================================================
