OK, I spoke too soon. I'm still not able to use Report Footer totals in
Break point calculations
I'm using DBCalcs for summing and have no expressions defined; per
Razzak's suggestions, I've predefined all variables and set them to null.
Using the SubTotalsAndTotals report as an example, how would I set up
that report to use the Grand Total to, let's say, calculate each
customer's Sub-Total as a percentage of the Grand Total?
Is there an example in RRYB14 of using a report footer total in break
point calculations? (I think I went through all the reports and didn't
find one but I could easily have missed it).
TIA
Doug
Doug Hamilton wrote:
Perfect timing, Les. I'm trying to do the same thing - I'm using
DBCalc in a report footer to sum miles & gallons, the using those totals
to do some calculations in a break footer above but I couldn't get it
to work - even set for two passes, the totals weren't showing above..
Then I found the trick after studying the SalesSumAndSubTot report in
RRBYW14.
Place the DBCalcs in the HEADER and use the GETPROPERTY to snag the
values in a Before Generate EEP in the RH. Not sure if that's the
most correct way but its working.
I was muckin' around with the Pass setting and Lookahead but they're
unnecessary. I changed the Two Pass (Report|PassSetting) to One. I
thought Lookahead was needed but apparently not (in this case).
I'm gonna keep pluggin' away but wanted to get this out hoping it will
help you.
Doug
Les Stark wrote:
I tried calculating it in report footer, page footer, detail, etc,
.... nothing worked and I cannot use the dbcalc because this variable
is used as part of another variable in a calculation.
--- 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.
================================================
