Tuesday, May 23, 2017
Tip of the Day: Understanding the DB Calc Object
Product.......: R:BASE X/X Enterprise (Version 10)
Build.........: 10.0.2.20411 or higher
Section.......: Reports, Labels
Keywords......: DB Calc, Aggregate, Function,
The DB Calc object is a data-aware control within the Report/Label
Designer used
to perform aggregate function calculations, and display the resulting
value. The
calculation can be based upon a COUNT, SUM, MINIMUM, MAXIMUM, and AVERAGE of a
column/field value. The DB Calc can eliminate the use of aggregate
functions used
in report/label expressions, allowing the report engine to perform
the calculations.
After a DB Calc object is added to a report/label, use the Edit
toolbar to specify
the column/field to based the calculations upon.
[]
Then, right click on the DB Calc object and select "Calculations" to
specify the
calculation properties.
[]
The "Calc Type" property determines what type of aggregate function
is performed
for the control. The "Reset Break" property (optional) is available to reset a
calculated value to zero each time the Report Break is encountered.
The Break name
can be selected from the list of defined Breaks.
. Count - count one for each row in a break
. Sum - sum data values for each row in a break
. Minimum - minimum data value for each row in a break
. Maximum - maximum data value for each row in a break
. Average - average of all data values for each row in a break
The "Look Ahead" option, available through the right click menu for
the DB Calc, is
designed to display summary calculations in the title band, page
footer calculations
in the page header band, group footer calculations in the group
header band, and
column footer calculations in the column header. When the Look Ahead
property is
checked, the draw command which represents the component on the
rendered page will
continue to update with the most recent calculation value until the
report completes
the generation of the associated page or break. Note: The report
"Pass Setting"
property must be set to "Two Pass" in order for Look Ahead
calculations to function
reliably.
The DB Calc is the fast and powerful method to perform aggregate
function calculations
on your reports and labels.
One of the most important aspects in business growth is your company
data, and no
one else has more invested in your success than R:BASE Technologies.
Invest forward
with R:BASE!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
