Expanding Rows and Columns

You can use the design-time row, column, and cell to reference the calculated rows, columns, or cells.

Row or Column Syntax:

            AXIS[Segment(Range)].Property
         

Cell Syntax:

            CELL[Row Segment(Range), Column Segment(Range)].Property
         

Parameters:

Parameter	Description
AXIS	Row or column containing the expanded cells identified by the row and column templates. For example, [3] refers to row 3 and [C] refers to column C. For example,[3].sum in a column formula is calculated as the sum of row 3. The default is row.
CELL	Intersection of the expanded cells, given the row and column template coordinates, respectively. For example, [2,C] is the single cell where row 2 intersects column C.
Segment	Value that represents a row or column ID in the Report Designer. Referenced segments refer to design-time rows or columns, which can expand in the viewer. View-time rows and columns are the expanded rows and columns. Use numbers for row IDs and letters for column IDs. Note: If you are using an expanded formula row, the default segment is row. If you are using an expanded formula column, the default segment is column. For example, row [ 5 ] refers to expanded row 5. For more information on segments, see Expressing the Segment Argument.
Range	Expanded cells used in the calculation of the function. Range refers to view-time expanded rows and columns. Calculations are performed after suppression. Sorting is performed after calculations. For more information on sorting and suppression, see Using Conditional Suppression and Sorting Rows, Columns, or Pages in Grids. Use colons to refer to a range of expanded rows or columns. For example, (3:6) addresses rows 3, 4, 5, and 6. For more information on ranges, see Expressing the Range Argument.
Property	Function applied to aggregate rows, columns, or cells. For more information on using properties, See Aggregate Property Arguments.