Databases Reference
In-Depth Information
Function
Description
Returns the least value for a range of values.
MIN()
Returns the standard deviation.
STDEV()
Returns the population standard deviation.
STDEVP()
Returns a sum of all values.
SUM()
Returns the variance of all values.
VAR()
Returns the population variance of all values.
VARP()
In addition to the aggregate functions in the previous table, the functions listed in the following table
behave in a similar way to aggregates but have special features for reports.
Function
Description
Returns an integer value for the group level within a recursive
hierarchy. The group name is required.
LEVEL()
Returns the row number for a group or range.
ROWNUMBER()
Returns an accumulative aggregation up to this row.
RUNNINGVALUE()
Examples of aggregate function expressions and recursive levels are found in the following sections for
table and matrix report items.
Using the Expression Builder
You've already used a few expressions in the basic report design work you've done so far. Any field
reference is an expression. In the Grouping and Sorting Properties dialog, you used a field expression.
In the report shown in the previous example, I used an expression to show the page number and total
pages so that it reads “Page X of Y.” Expressions are used to create a dynamic value based on a variety of
global variables, fields, and programming functions. Expressions may be used to set most property val-
ues based on a variety of global variables, field values, and calculations. Let's take a quick look at com-
mon methods to build simple expressions.
To display the page number and page count, add a text box to the page header or footer. Right-click
the text box and in the drop-down list select Expression. Use the Edit Expression window to create the
expression. There are two different ways to enter an expression. The first method is to select and paste
items from the object tree and member lists (shown in Figure 6-32). You can either double-click an item
or click the Paste button to add items to the expression. The other method is simply to type text into the
expression text area. As you type, you may use the IntelliSense Auto List Members feature to provide
drop-down lists for known items and properties. When you type a known object (for example, Globals
or Fields) followed by a period or exclamation mark, a list of members will appear at this location. You
may continue to type or select a list item using the mouse or keyboard arrow keys. When the appropri-
ate list item is highlighted, use the Tab key to select it from the list.
Search WWH ::
Custom Search