- This returns the mean value of the specified column. The syntax is average(<Column Field>). To return the average value of a column field named UnitPrice, you would use the following formula: average({UnitPrice}).

- This returns the median value for the specified column. The syntax is median(<Column Field>). If the median of the column is two values (for an even number of rows), the aggregation will return the average of the two values.

- This returns a count of the values in the specified column. The syntax is count(<Column Field>).

- This returns a count of all the distinct values in the specified column The syntax is countdistinct(<Column Field>).

- This returns the maximum value for the specified column. The syntax is max(<Column Field>).

- This returns the minimum value for the specified column. The syntax is min(<ColumnField>).

- This returns the standard deviation for the specified column. The syntax is stddev(<Column Field>).

- This returns the sum of the specified column. The syntax is sum(<Column Field>).

- This returns the sum of squares for the specified column. The syntax is sumsquare(<Column Field>).

- This returns the variance for the specified column. The syntax is variance(<Column Field>).

This will return the absolute value of a number. The syntax is abs(<Number>). For example abs(-12) would return 12.

This will return the arc cosine of an angle, in the range of 0 through pi. Syntax for this is acos(<radians>). For example, acos(-sqrt(2)/2) would return 3*pi/4.

This will return the arc sine of an angle in the range of -pi/2 through pi/2. The syntax is asin(<radians>). For example, asin(sqrt(2)/2) would return pi/4.

This will return the arc tangent of an angle in the range of -pi/2 through pi/2. The syntax is atan(<radians>). For example, atan(1) would return pi/4.

This will convert rectangular coordinates (b, a) into polar coordinates (r, theta). This function returns theta by taking the arc tangent of b/a in the range of -pi to pi. The syntax is atan2(<y_coordinate>, <x_coordinate>). For example atan2(1,0) would return pi/2.

This will return the lowest integer value that is greater than the specified number. The syntax is ceil(<Number>). For example, ceil(15.3) would return 16.

This will return the cosine of an angle in radians. The syntax is cos(<radians>). For example cos(3*pi()/4) would return -sqrt(2)/2.

This will return the value e, the natural logarithm base. The syntax is e() without any arguments.

This will return e raised to the nth power. The syntax is exp(<Number>). For example exp(3) would return e^3 or 20.086.

This will return the factorial of the specified object. The syntax is factorial(<Number>). For example factorial(3) would return 6.

This will return the highest integer value that is less than the specified argument. The syntax is floor(<Number>). For example floor(5.52) would return 5.

This will return an integer indicating the total number of columns in the report. The syntax is getColumnCount() without any arguments. This function returns the total number of columns whether they are visible or not.

This will return an integer indicating the index value of the current row (of Table Data) of the report. The syntax is getRowIndex() without any arguments.

This will return a count of all the rows (in Table Data) in the report. The syntax is getTotalRowIndex() without any arguments.

This will return the current row in the current group (table) in a report. This function is generally only relevant in reports that have grouped data like the summary break and master & details layout. For example, if the current row is the third row in a group of data getRowIndexOfCurrentTable() will always return 2 regardless of what the row index is for the total report (which you could retrieve using the getRowIndex() function). The syntax is getRowIndexOfCurrentTable() without any arguments.

This will return a count of all the rows in the current group (table) in a report. This function is generally only relevant in reports that have grouped data like the summary break and master & details layout. The syntax is getTotalRowIndexOfCurrentTable() without any arguments.

This will return a count of the number of sibling groups within a nesting level. This function is generally only relevant in reports that have grouped data like the summary break and master & details layout. For example, say you have a summary break report with one level of grouping. There are three distinct values in your row break column creating three groups at the level. Within the group (i.e. Group Header, Table Data, or Group Footer sections) getSiblingCount() would return 3. The syntax is getSiblingCount() without any arguments.

This will return a count of the number of child groups inside a nesting level. This function is generally only relevant in reports that have grouped data like the summary break and master & details layout. For example, say you have the same example as described for the previous function. Within the group the getChildCount() function would return 0 as there is only one level of grouping. However, outside the group (i.e. Table Header or Table Footer sections) getChildCount() would return 3. The syntax is getChildCount() without any arguments.

This will return an integer indication the index value of the current group. This function is only relevant in reports that have grouped data like the summary break and master & details layout. This function will only return the index of the inner most group for reports with nested groups.

This will return the natural logarithm of the specified number. The syntax is log(<Number>). For example log(10) would return 2.303.

This will return the remainder after dividing two numbers. The first argument is the numerator and the second is the denominator. The syntax is mod(<Number>, <Number>). For example mod(12, 7) would return 5.

This will return the value pi. The syntax is pi(), without any arguments.

This will return the value of the first argument raised to the power of a second argument. The syntax is pow(<Number>, <Number>). For example pow(2, 3) would return 8.

- This will return a random value greater than or equal to 0 and less than 1. The syntax is random() without any arguments.

This will round the specified argument to the nearest integer. The syntax is rint(<Number>). For example rint(5.6) would return 6.

This will return the sine of an angle in radians. The syntax is sin(<radians>). For example sin(pi()/2) would return 1.

This will return the square root of the specified number. The syntax is sqrt(<Number>). For example sqrt(64) would return 8.

This will return the tangent of an angle in radians. The syntax is tan(<radians>). For example, tan(pi()/4) would return 1.

- This will convert an angle measured in radians to degrees. The syntax is toDegrees(<Number>). For example, toDegrees(pi()) would return 180.

This will convert an angle measured in degrees to radians. The syntax is toRadians(<Number>). For example, toRadians(180) would return 3.142.

- This will convert a number into a string. The syntax is toString(<Number>, <Number of Decimals>, <Round Up(True/False)>). For example toString(12.216, 2, True) would return "12.22" as a string.

Returns whole row of data in a format like (COLUMN1_NAME) VALUE1 (COLUMN2_NAME) VALUE2 ... Does not require any arguments.

This will return the column name for a column field. The syntax is getHeader(<Column Field>). For example, if you have a column named UnitPrice, getHeader({UnitPrice}) would return UnitPrice as a string.

This will return the current page number. The syntax is getPage() without any arguments.

This will return the total number of pages for the current report. The syntax is getTotalPages() without any arguments.

This will return the total number of sections (i.e., the number of pages needed horizontally) for the current report. The syntax is getTotalSections() without any objects.

This will return the first index value where a specified pattern within a string occurs. There are two syntaxes for this function.

- This allows you to insert new characters into a string. The syntax is insert(<String>, < Character Number>, <New Characters>). For example insert("Wood Natural Furniture", 4, "View") would return WoodView Natural Furniture.

This will return the last index value where a specified pattern within a stringoccurs. There are two syntaxes for this function.

This allows you to replace one set of characters in a string with another. There are two syntaxes for this function.

This allows you to set the maximum length of a string. The syntax is setMaxLength(<String>, <Maximum Number of Characters>). For example, setMaxLength("You're a firefighter",13) would return You're a fire.

- This compares two strings and returns the lexicographical difference between them. If the first argument is larger than the second, the result is positive. If the first argument is smaller than the second, the result is negative. If the strings are the same, then the result is zero. The syntax is strcmp(<String>, <String>). For example, strcmp("a", "c") would return -2.

This compares two strings and returns the lexicographical difference between them while ignoring case. The syntax is strcmpIgnoreCase(<String>, <String>). For example, strcmpIgnoreCase("a", "A") would return 0.

This concatenates multiple strings together. The syntax is strcat(<String>, <String>, <String>...). For example strcat("Wood", "View") would return WoodView. You can also use the "+" operator to concatenate strings.

- This will return an integer indicating the number of characters in a specified string. The syntax is strlen(<String>). For example strlen("ReportDesigner") would return 14.

- This will return a portion of a string as specified by an argument. There are two syntaxes for this function.

This will remove any leading or trailing spaces from the specified string. The syntax is trim(<String>). For example, trim(" Hello ") would return Hello.

This will render any uppercase letters within the specified string to lowercase. The syntax is toLowerCase(<String>). For example toLowerCase("ABCdef") would return abcdef.

This will turn a string into a double. The syntax is toNumeric(<String>). For example toNumeric("425.52") would return 425.52. For this formula to work correctly the string argument must contain numeric characters.

This will render any lowercase letters within the specified string to uppercase. The syntax is toUpperCase(<String>). For example toUpperCase("ABCdef") would return ABCDEF.

This adds a specified amount of time to a given date/time. The syntax is addTime(<Date/Time>, <Calendar Field>, <Number>). The number specifies the amount that the calendar field should be added to the date/time object. For example, addTime(12/5/1998, MONTH, 5) would return May 5, 1999, and addTime(12/5/1998, DAY_OF_MONTH, -25) would return Nov, 10 1998.

This will return AM or PM as a string for a given time. The syntax is getAmPm(<Time>). For example, getAmPm(13:24:00) would return PM.

This will return the current date from the system. The syntax is getCurrentDate(), without any arguments.

This will return the current date and time from the system. The syntax is getCurrentDateTime(), without any arguments.

This will return the current time from the system. The syntax is getCurrentTime(), without any arguments.

This will return the value of a specified calendar field for a given date/time. The syntax is getDateTime(<Date/Time>, <Calendar Field>). For example, getDateTime(12:24:00, MINUTE) would return 24, and getDateTime(10/10/2001, DAY_OF_WEEK) would return 4 (meaning Wednesday).

This will return the difference in days as an integer between two dates. The syntax is getDayDifference(<Date>, <Date>). For example, getDayDifference(5/1/2001, 3/1/2001) would return 61. You can also use the "-" operator to return the difference between to dates.

This will return the day of the week for the specified date. The syntax is getDayOfWeek(<Date>). For example, getDayOfWeek(10/10/2001) will return Wednesday as a string.

This will return the era for the specified date. The syntax is getEra(<Date>). For example, getEra(10/10/2000) would return AD as a string.

This will return the month for the specified date. The syntax is getMonth(<Date>). For example, getMonth(10/10/2000) would return October as a string.

This is a time rolling function. The syntax is rollTime(<Date/Time>, <Calendar Field>, <Number>). Unlike the addTime() function, this function will only adjust the specified calendar field by the specified amount, and will have no effect on the other fields. For example rollTime(12/5/1998, MONTH, 5) would return May 5, 1998, and rollTime(12/5/1998, DAY_OF_MONTH, -25) would return Dec 11, 1998. For the latter example, when the count reaches the beginning of the month, it starts over at the end without changing the month field.

These three functions allow you to set the way in which date/time information is displayed beyond what is capable through the data formatting options. These functions will return date and/or time information as a string. Their syntax is as follows:

printDate(Date, Date Format)
printDateTime(Date, Date & Time Format)
printTime(Time, Time Format)

The date and/or time format is entered as a series of characters and delimiters. Letters are used to represent different elements of date/time data. The characters and what each represent are listed below:

You can piece together almost any combination of these characters to produce a date expression in the format that you would like. The count of groups of characters determines the form that the element will take. For text elements with four or more characters in a group,the full form of the element to be used. If less than four characters are used, the short form will be used if one exists. For example EEEE would return Monday and EE would return Mon. For month M which can display as either text or a number, four or more in a group will display the full version, three will display the abbreviation, and two or less will display the number form.

For numeric elements, the count of characters is the minimum number of digits that the element will take. Shorter numbers will implement leading zeros. For example if the day of the date is 2, dd would return 02 and d would return 2.

Any character that is not a-z or A-Z like “;”, “:”, “@”, etc can be inserted anywhere within the string expression and will display as they are entered. You can also insert words and expressions by enclosing them within single quotes (type two single quotes to insert an apostrophe as text). Several examples are listed below:

printDateTime(10/10/2001 21:15:12, "MMMM dd, yyyy 'at' hh:mm a z") would return October 10, 2001 at 9:15 PM PDT

printDate(10/10/2001, "EEE MMM dd'th', yyyy") would return Wed Oct 10th, 2001

printTime(13:22:12, "h 'o''clock' m 'minutes and' s 'seconds'")would return 1 o'clock 22 minutes and 12 seconds

printDateTime(10/10/2001 13:22:12, "MM/dd/yy HH:mm:ss") would return 10/10/01 13:22:12

If you do not enter any information for the date/time format, the date will display as yyyy-mm-dd and the time will default to HH:mm:ss.S. So printDateTime(10/10/2001 13:22:12) would return 2001-10-10 13:22:12.0.

This will convert a long integer into a timestamp. The syntax is toDate(<Number>). For example, toDate(1025039526306) would return Jun 25, 2002 2:12:06 PM.