But if I use a Sum Of for a page and I want to put it in the page
header, then do I have to use two passes and count passes - once to calc
and the 2nd time display? That's a crock.
At least DBCalc has the LookAhead; just gotta figure out how to reset it
so it has only the total for the current page.
Maybe I'll try using the system page number as a break point.
Should it be this convoluted?
D
On 3/15/2013 3:48 PM, Doug Hamilton wrote:
I don't think you're doing anything wrong, Javier. That's what I've
found also.
I'm setting up a traditional Sum Of variable to reset on page break
rather than using the DBCalc.
I also tried using the system var PageNumber and reset on that but it
didn't work.
Doug
On 3/15/2013 3:37 PM, Javier Valencia wrote:
Dennis and Tony,
When I right click on the DBCalc field and select Calculation or Reset
Breaks, both options display only the defined breaks and not the
Page Break
(Ver. 9.5), the only place where I can reset variables at the Page
level is
by selecting Report>>Break and then going to the On Page Break>>Reset
Vars;
am I doing something wrong?
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis
McGrath
Sent: Friday, March 15, 2013 3:03 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Reset DBCalc on Page Break
right click on the dbcalc.
click on calculations
select the break you want to reset on
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tony
IJntema
Sent: Friday, March 15, 2013 2:36 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Reset DBCalc on Page Break
Doug,
Maybe I am mistaking, but in the report writer you are able to reset
variables on page break.
Tony
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Doug
Hamilton
Sent: vrijdag 15 maart 2013 20:07
To: RBASE-L Mailing List
Subject: [RBASE-L] - Reset DBCalc on Page Break
How do I reset a Sum DBCalc on page break?
It's in a page header intended to calc the sum of InvTotals on that
page.
I added a page number sys var and have the DBCalc reset on the page
number,
but that shows the total for all pages on each page.
RB 7.6 31014
TIA,
Doug
I think my report braincell has taken Friday off.
