At 09:54 AM 4/21/2005, Carole et Michel wrote:
I converted one of my reports from 6.5, there is only one
break on that report. I have a var on the break footer that
is a SUM OF another var, the first time it breaks I get a
good value but every other time I get $5,398,623.14 as value
and I get that same value on all the other vars I reset for
that report. I tried desining a new report and the same thing
is hapening. I have had the value of $5,398,623.14 apearing
other reports and forms variables but managed to work around
it but I dont know where that value comes from.
Carole,
A few suggestions:
01. Make sure that the variable(s) in question are defined
to evaluate for appropriate bands of the report.
Report Designer | Variables | Add/Edit Variables
Define Expressions | Highlight the variable and select
the appropriate band for "Calculate On:"
02. Make sure that appropriate variable(s) are "Reset"
accordingly, for each break defined.
Report Designer | Report | Breaks | Highlight the break
Click on [Reset Vars] button
Check all variables to reset accordingly.
03. Make sure that [ ] Clear Variables After Printing option
is also checked.
Report Designer | Variables | Clear Variables After Printing
04. Take a look at the sample "SubTotalsAndTotals" report in
ConComp database to understand the proper logic of using
Totals and Sub-Totals based on Variables.
Database: ConComp
Report: SubTotalsAndTotals
Command File: Reports13_SubTotalsAndTotals.rmd
Process: RUN Reports13_SubTotalsAndTotals.rmd
05. LBNL, use "DB Calc" anyway you can.
Hope that helps!
Very Best R:egards,
Razzak.
