Formatting a table

You can format a table by changing column labels, sorting, and sizing. You can also change data format and the level of detail displayed.

1. To add a title to a table, click Click to add a title and enter a title.
2. Edit a column header or label.
   1. In the Ad Hoc view pane, right-click the column or group header you want to rename and select Edit Label.
   2. Delete the existing name and enter a new name.
3. Resize a column.
   1. In the Ad Hoc view pane, select the column to resize.
   2. Move the cursor to the right edge of the column, click and drag the column to a new position.
4. Add spacing between columns.
   1. In the Data Source Selection pane in the Measures section, click Spacer.
   2. Drag the spacer into the Columns box in the Layout Band between the names of the two columns you want to add the spacer to. Repeat until the margins are as wide as needed.
5. Create table margins.
   1. In the Data Source Selection pane, click to select Spacer.
   2. Drag the spacer into the Columns box in the Layout Band, and repeat until the margins are as wide as needed.
   3. Add spacers to the right edge of the table.
6. To reorder a column, in the Ad Hoc view pane, right-click the column to move and select Move Right or Move Left.
7. Sort a table.
   1. Click to open the Sort window.
      If the table is already sorted, the window shows the fields that are used.
   2. To add a field to sort on, double-click the field in Available Fields.
   3. Select one or more fields to sort by.
      Use the Ctrl key to select multiple fields.
   4. To arrange the sorting precedence of the fields, select each field in the Sort window and click , , , or .
   5. Click OK.
8. Change the data format for a column.
   1. In the Ad Hoc view pane, right-click the column and select Change Data Format.
   2. Select the format that you want to use.
      Options vary, depending on the type of numeric data contained in the column.
9. To reorder a column, in the Ad Hoc view pane, right-click the column to move and select Move Right or Move Left.
10. To show or hide detail rows, place the cursor over and select Hide Detail Rows or Show Details Rows.

    A summary is applied to each field dependent on its data type, or the complete information for the row is displayed.

11. To control the data set in the grid, click .
    • Detailed Data. Displays table detail only.
    • Totals Data. Displays the table totals only.
    • Details and Totals. Displays both details and totals data.