Inserting Rows and Columns

You insert rows or columns into a grid to add data to the grid. Types of rows and columns include:

• Data—Members of dimensions that are retrieved from a database connection. The member in a data row or column defaults to the top-level member of the dimension.

  A # symbol indicates data rows, columns, or cells.

• Formula—Values based on formulas. Commonly used to calculate totals, averages, and variances on data rows or columns.

  An = # symbol indicates formula rows, columns, or cells.

• Text—Text typed into the cells or added dynamically through a text function.

  Text rows, columns, or cells in grids do not contain symbols when added to a grid. They are initially blank until populated with text.

When you add a grid to a report, it contains one of each of the following:

• Data row

• Anchor row

• Data column

• Anchor column

An anchor row or column is a blank row or column located at the end of the rows or columns. You can add one or more rows or columns in a grid, or you can use the anchor row and column to append new rows and columns.

To insert a row or a column in a grid:

1. In an existing grid, select a cell, row, or column.
2. Select Insert, then Row or Column, and then Data, Formula, or Text.

   To insert multiple rows or columns, select the number of rows or columns on the grid equal to the number of rows or columns that you want to insert.

3. Populate the row or column:

   • For a data row or column, double-click the row or column heading and select dimension members to place in the row or column. See Assigning Members to Data Rows or Columns.

   • For a formula row or column, select the row or column heading and build a formula in the formula bar at the top of the Report Designer.

   • For a text row or column, enter text directly in the row or column, in the formula bar at the top of the Report Designer, or in Text Properties. See Formatting Text Objects.

Note: Text in a text cell, that extends beyond the width of the cell, does not extend to fill the adjacent cells when rendering the report output. The text content will wrap in the single cell. When creating long text that does not fit in a single grid cell, use a text box below the grid instead.