At 12:26 PM 4/29/2010, Les Stark wrote:
I have a report in 7.6 that is sometimes two pages long. It
uses VARNAME=(SUM OF COLNAME) in order to compute another
variable in the report footer. The SUM OF variable leaves
off the first item of the second page of the report in the
sum. What am I missing? --
Les,
While we strongly recommend using DB Calc to replace "any
calculation" carried over from a LEGACY report, here are
a few suggestions to make sure that all variables defined
as expressions in report are calculated and re-set
accordingly.
01. Make sure that all sub-totals and totals are calculated
on the correct Section/Band of the report.
While in Report Designer, take a look at the Expression
Builder and carefully review all variables, especially
the Section. Then verify all variables for exact placement
on report band.
02. Make sure that all variables are pre-defined with correct
data type and are initialized as NULL prior to generating
the actual report.
To achieve this functionality as a consistent routine,
take advantage of the "On Before Generate Action".
Report Designer|Main Menu|Report|Actions|Before Generate...
03. Always make sure to either CLEAR or RESET variables after
the report is actually generated.
To achieve this functionality as a consistent routine,
take advantage of the "On After Generate Action".
Report Designer|Main Menu|Report|Actions|After Generate...
04. You may also CLEAR variables by checking the Clear Variables
After Printing option in report designer.
Report Designer|Main Menu|Variables ...
Adhering to these basic rules will always provide you with
consistent results.
Last but not least, make sure that you are using the latest
updates of R:BASE 7.6, Turbo V-8, or R:BASE eXtreme 9.0 (32/64).
Here is a sample report for your viewing pleasure ...
http://www.razzak.com/sampleapplications/SubTotalsAndTotals.pdf
Hope that helps!
If you need a sample application with such scenarios to explain
and demonstrate the suggested techniques, feel free to send me
a private e-mail.
Very Best R:egards,
Razzak.
