Inserting Rows or Columns in Grids

You insert rows or columns into a grid to add data to the grid.

Table 12. Row and Column Types

Type	Description
Data	A data row or column contains 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. Note: A # symbol is used to indicate data rows, columns, or cells in grids.
Formula	A formula row or column displays values based on specified formulas. A formula row or column is commonly used to calculate totals, averages, and variances on data rows or columns. . Note: An = # symbol is used to indicate formula rows, columns, or cells in grids.
Text	A text row or column primarily contains text typed into the cells, or added dynamically through a text function. Note: Text rows, columns, or cells in grids do not contain symbols when added to a grid. They are initially blank until populated with text.

By default, when you add a grid to a report, it contains one of each of the following components: a data row, an anchor row, a data column, and an anchor column. An anchor row or column is a blank row or column located at the end of a row or column. You can add one or more rows or columns within a grid, or you can use the anchor row and column to append new rows and columns.

Tip:	Use the formatting information provided in Formatting Grids to format the grid you added to your report.

The grid boundary remains the same size as you add rows and columns. For information on resizing the grid, see Resizing Report Objects.

To insert rows or columns in grids:

Select a cell or a row or column, then select Insert, then Row/Column, then Data, and then Formula, or Text. The new row is inserted above the selected row; the new column is inserted to the left of the selected column.
Tip:
To insert multiple rows/columns, select a number of rows or column on the grid equal to the number of rows or columns you want to insert.
To append a row or column at the end of a grid, select the grid or an anchor row or column, then perform an action:
- For a row, select Insert, then Row, then Data, and then Formula, or Text.
- For a column, select Insert, then Column, then Data, and then Formula, or Text.
To populate the row or column with data, formula, or text, perform an action:
- For a data row or column, double-click the row or column heading and select dimension members to place on the row or column. For more information, 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.
- For a text row or column, enter text directly into the row or column. For more information on formatting text rows or columns, see Formatting Text Boxes.
  Note:
  To delete a row or column, select the desired row or column, then select Edit, and then Delete.