Skip to main content

Managing Column Size and Spacing

Last updated: Thu, 27 Apr 2017 19:07:04 GMT
iOffice Support

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.

Hiding Columns

To hide a column, click the column you want to hide, then move your mouse over the formatting icon ( ) and select Hide column

Sorting Tables

  1. Click The Sort window appears. 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 FieldsThe Available Fields panel now lists only fields that are already on Sort On.

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

  4. Click  .

  5. 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:  ,  ,  , and .

  6. To remove a field, select it and click .

  7. 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 .

  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 .

  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 tool bar.

  • 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 Home

Dashboards

Creating a Report