At 12:55 AM 7/28/2008, Patti Jakusz wrote:
I can't figure out what I'm doing wrong.
Patti,
A few suggestions:
01. Pre-define all variables (with correct Data Type) as NULL using the
"Before-Generate..." action in report designer.
Report Designer | Main Menu | Report | Actions | Before Generate ..
-- Example:
SET VARIABLE vCount INTEGER = NULL
SET VARIABLE vSubTot INTEGER = NULL
SET VARIABLE vGrTot INTEGER = NULL
02. Re-visit all report "Breaks", if defined, and make sure that all
appropriate variables are "Reset" accordingly.
03. Make sure that the option for "Clear Variables After Printing"
is checked.
Report Designer|Main Menu|Variables|Clear Variables After Printing
I don't want to use DB Calc, because I want to use the subtotals in
other expressions.
Actually, you can, using the supported GETPROPERTY command in reports.
Take a look at the "Capturing DBCalc Results as Variables in Reports",
sample application, included in the Super Advanced Training CD.
Also, to understand the proper use of report "Sub-Totals and Grand Totals"
(DB Calc vs SUM OF colname), take a look at the "SubTotalsAndTotals"
report included with the Running R:BASE Your Way! (Part 14), included
with the full installation of R:BASE 7.6 for Windows.
Here's a report that demonstrates everything!
http://www.rbase.com/rbg76/reports/SubTotalsAndTotals.pdf
Notice the "Sub-Total and Grand Total Using DB Calc Option" versus
the "Sub-Totals and Totals Using SUM OF Option".
Hope that helps!
Razzak.
