Text Function Considerations

Note:

If you don’t explicitly specify a row or column in a text function that supports row or column, then the current row or column is used by default.

• You can use spaces between arguments.

• All arguments are enclosed in quotes, except for numeric arguments.

  For example, the parameter "NYC, New York" in the function MemberName("Grid1", NYC, New York) should be restated as MemberName("Grid1", "NYC, New York").

• Arguments related to date formatting are case-sensitive.

• Text functions can be entered in a text box, row, or column.

• To apply text functions to a grid, create a text row or column, or a heading cell, and then insert the text function.

• When you insert a text function into a text row or column, by default the text function applies to the current grid. Therefore, the text function builder does not include a selection for the Grid parameter. If the text function refers to another grid in the report, specify the Grid parameter after you insert the function.

List of Functions in the User Interface

When you launch the function builder, a list of functions that are appropriate based on the context of that function is displayed. While any text function is allowed in either a text object or grid object text or heading cell (with the exception of RowNumber/ColumnNumber, as described in Validation Errors), to provide guidance about which functions are most relevant for a given context, we show one of the following filtered lists:

• Grid text cell: CellValue, CellText, HeadingValue, MemberName, MemberAlias, MemberProperty, RowNumber, ColumnNumber

• Text Object in report body: CellValue, CellText, DateTime, MemberName, MemberAlias, MemberProperty

• Text Object in header/footer: DateTime, CellValue, CellText, MemberName, MemberAlias, MemberProperty, PageNumber, PageCount, ReportAuthor, ReportCreatedOn, ReportModifiedBy, ReportModifiedOn, ReportName, ReportDescription, ReportLocation, ReportRunBy