Skip to main content

Column and Header Labels

Last updated: Thu, 27 Apr 2017 19:06:50 GMT
iOFFICE Knowledge Center

Column and Header Labels

You can edit a column or header label.

Editing a Column or Header Label

  1. On the Reports view panel, right-click the column or group header you want to rename.

  2. Select Edit Label from the context menu. The Edit Label window opens.

  3. In the text entry box, delete the existing name and enter the new name.

  4. Click Submit.

 

If space is at a premium, you may remove labels from the view. When you delete a label, it still appears when you look at the view in the Reports Editor, but does not appear when you run the report.

Deleting a Column or Header Label

  1. On the Reports view, right-click the column or header label you want to remove.

  2. Select the Delete Label from the context menu.

Re-applying a Label

  1. Right-click the column or header label you want to replace.

  2. Select Add Label from the context menu. The Edit Label window opens.

  3. Enter the label name, if needed.

  4. Click Submit.

Managing Column Size and Spacing

You are able to change the size and space between columns to more efficiently manage the appearance of your table.

  • Select the columns you want to adjust by clicking anywhere in the column.

Resizing a Column

In the Reports View panel, click to select the column you want to resize.

  1. The selected column highlights, and you are able to increase or decrease the size by dragging the column to the left or right.

  2. Once you are done modifying your columns, select the DONE button. 

Changing the Spacing Between Columns

In the Data Source Selection panel, in the Measures section, click Spacer.

  1. Drag the spacer into the Columns box in the Layout Band between the names of the two columns you want to move apart.

             A spacer column, labeled , appears in the table.

  1. Repeat this action to add space between each of the columns.

  2. To remove a spacer, right-click the spacer column and select Remove from Table.

Using Spacers to Create Table Margins

  1. In the Data Source Selection panel, click to select Spacer.

  2. Drag the spacer into the Columns box in the Layout Band.

  3. Repeat as needed until the margins are as wide as necessary.

  4. Repeat the steps above, adding the spacer to the right edge of the table.

Reordering Columns

You can move columns to the right or left to reorder data in your table.

  1. In the Reports View panel, right-click the column you want to move.

  2. Select Move Right or Move Left from the context menu.

Sorting Tables

  1. Click sort_tables.png.

             The Sort window appears. If the table is already sorted, the window shows the fields that

             are used.

  1. To add a field to sort on, double-click the field in Available Fields.

             The Available Fields panel now lists only fields that are already on Sort On.

  1. Select one or more fields to sort by. You can also use CTRL-click to select multiple fields.

  2. Click right_arrow.png.

  3. To arrange the sorting precedence of the fields, select each field in the Sort window and click Move to top, Move up, Move down, or Move to bottom: up_up_arrow.png ,  up_arrow.png,  down_arrow.png, and  down_down_arrow.png.

  4. To remove a field, select it and click  left_arrow.png.

  5. Click OK. The table updates to display the rows sorted by the selected fields.

 

You can also sort a table using the following methods:

  • Right-click a field in the Fields section of the Data Source Selection panel, and select Use for Sorting from the context menu. In this case, the table is sorted by a field that is not in the table; you may want to note the sorting fields in the title.

  • Right-click a column header on the Canvas of the Reports View panel, and select Use for Sorting from the context menu.

 

Note: If a column is already being sorted and you want to stop using it or change the sorting, right-click the column and select Change Sorting from the context menu.  

Adding a Title

  1. Above the table, click the text Click to add a title.

  2. Enter the new table title in the text entry box.

Changing the Data Format for a Column

You can change the formatting for columns containing numeric data, such as dates and monetary amounts.

  1. In the Reports view, right-click the column for which you want to change the data format.

  2. Select Change Data Format from the context menu.

  3. Select the format you want to use. These options vary, depending on the type of numeric data contained in the column.

 

The data in the column now appears in the new format.

Hiding Detail Rows in a Table

  1. Place the cursor over detail_rows.png.

  2. Select Hide Detail Rows to show only the summarized total for each group.

             The Reports Editor applies a summary to each field depending on its data type.

Showing Detail Rows in a Table

  1. Place the cursor over detail_rows.png.

  2. Select Show Detail Rows to display the detailed information for each group

             The Reports Editor displays the complete information in each row. 

Setting Output Scale

You can determine the display size for any report by using the report scaling options, located in the Report Viewer toolbar. 

  • Click + to zoom in on the report.

  • Click - to zoom out on the report.

  • Click the size field to open the Zoom Options drop-down menu, and select the percentage by which you want to increase or decrease the size of the displayed report.

The Bookmarks Panel

When working with a report that contains bookmarks, they are displayed in a floating panel. Using this panel, you can jump to designated sections of the report. 

 

 

Related Topics

Reports Module Home

Dashboards Home

Creating a Report