Please enable JavaScript to view this site.

R:BASE 11 Beginners Tutorial

Navigation: Lesson 5 - Report Output

Choosing DB Calc over using a computed variable in reports

Scroll Prev Top Next More

The DB Calc object in the R:BASE Report Designer can replace the use of COUNT, MINIMUM, MAXIMUM, AVERAGE, and SUM aggregate functions for column expressions used in earlier versions of R:BASE. The DB Calc object can be used in locations where a variable would be used to for a count, minimum, maximum, average and sum computation for a column.

 

However, there are instances where you must use a variable instead of a DB Calc object. If you plan to use the result of the DB Calc object in the expression of another variable, then you must use a variable for the actual COUNT, MINIMUM, MAXIMUM, AVERAGE and SUM for the column.