This option 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 can use the following formula: average({UnitPrice}).

This option 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 option returns a count of the values in the specified column. The syntax is count(<Column Field>).

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

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

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

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

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

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

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

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

This option 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 option 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 option 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 option 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 option 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 option 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 option will return the value e, the natural logarithm base. The syntax is e() without any arguments.

This option 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 option will return the factorial of the specified object. The syntax is factorial(<Number>). For example factorial(3) would return 6.

This option 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 option 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 option 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 option will return a count of all the rows (in Table Data) in the report. The syntax is getTotalRowIndex() without any arguments.

This option 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 option 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 option 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, 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 option 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. The function will return the number of child group in outer most group when running in a table header or a table footer; It will return the number of child in the related group when running in a group footer/header. For example, 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 option 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 option will return the natural logarithm of the specified number. The syntax is log(<Number>). For example log(10) would return 2.303.

This option 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 option will return the value pi. The syntax is pi() without any arguments.

This option 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 option will return a random value greater than or equal to 0 and less than 1. The syntax is random() without any arguments.

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

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

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

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

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

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

This option 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.

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

This option 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 option will return the current page number. The syntax is getPage() without any arguments.

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

This option 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 option will return the first index value where a specified pattern within a string occurs. There are two syntaxes for this function.

This option 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 option will return the last index value where a specified pattern within a string occurs. There are two syntaxes for this function:

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

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

This option 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 option 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 option 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 option will return a portion of a string as specified by an argument. There are two syntaxes for this function:

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

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

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

This option 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 option 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 option will return the current date from the system. The syntax is getCurrentDate() without any arguments.

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

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

This option 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 option 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 dates.

This option 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 option will return the week of the year for the specified date. The syntax is getWeekOfYear(<Date>). For example, getWeekOfYear(10/10/2001) will return 41.

This option 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 option 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 option 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 using 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 of them represent are listed below:

You can piece together almost any combination of these characters to produce a date expression in any format you want. 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 will be used. If less than four characters are used, the short form will be used, if it exists. For example EEEE would return Monday and EE would return Mon. For month M which can be displayed 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 option 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.

This option will return a value of a column field according to the row index. To do this, you can append a column field with the following syntax: .row(Row Index). The row index is the index value associated with each row in a report starting with 0. For example {ProductName}.row(3) would return the fourth value of the ProductName field.

This option will return value of a column field according to the row index after applying script. If there is no script applied on the column, it returns the same value as .row(). See Section 1.9.2.9 - Accessing Values Computed by Other Scripts for more details.

This option will return the first value of a column field. The syntax is first(<Column Field>). For example first({UnitPrice}) would return the first value of the UnitPrice field.

This option will return the last value of a column field. The syntax is last(<Column Field>). For example last({UnitPrice}) would return the last value of the UnitPrice field.