Specifying Fields for a Table

In the Available Columns area, you can select the fields you want to display in the table, group multiple fields into a single column as needed, assign Alias names for column headings, specify a data sort order, and set column size and alignment options.

Available Columns for Tables
Attribute	Description
Groups	Optionally, you can sort data results from queries by grouping two or more fields into a single column. To create a group: Right-click in the Groups row for a column and choose Make Group. In the dialog, enter a name for the new group and add the selected field. To add fields to a group: Drag fields from the Fields row to the Groups row. Alternatively, right-click a field and choose Add to Group. In the dialog, enter a the group's name.
Fields	This displays fields as columns for your report. The field name is displayed as it is referred to in the database. This field is not editable.
Use	By default, all data entries are selected for use in the table. If you do not want to use all the available columns, uncheck the corresponding check box. Caution: If you de-select a data entry because you do not want to use that column in the report, the column is automatically pushed to the far right (the end of the table) to move it out of the way so that you can focus on the columns you are using. If you then select “Use” again for that same data entry, its column is re-inserted into its original position along with the other columns you have selected to use.
Function	To set a function on a field, click in the Function row for that field's column. Select the function you want to apply to the column from the Function drop-down menu. After the function is set, the field appears with the function icon (). Fields set with functions can be filtered in the Aggregation tab.
Alias	Enter a display name alias for the data column. For example, if the column is referred to as Source Translated Zone Name in the ArcSight database, you can shorten this name to Zone Name or Src Zone for display in the report table. In our example, we provide the aliases Time instead of Timestamp and Number of Logins for Category Outcome (Count).
Width	Set column Width to either of the following options: Auto - Automatically divides column width evenly among the selected columns User Specified Layout - This option requires that you enter numbers to specify percentage widths for individual columns.
Sort	Indicate the sort order for the data in each column.
H Align	Right-click in the H Align row to display a drop-down menu for specifying horizontal alignment of text in a given column. You can select text to be left- aligned, centered, or right-aligned in the corresponding column.
V Align	Right-click in the V Align row to get a drop-down menu for specifying vertical alignment of text in a given column. You can select for top, bottom, middle, or baseline text in the corresponding column.
Page Break	Right-click in the Page Break row in a column to get options for specifying a page break before or after the that column.

With the Custom Layout options, you can specify custom column widths for the data in the table. By default, the Custom Layout drop-down menu shows User Specified Layout, which enables you to enter a numeral to specify a percentage for individual columns. Select one of the following:

Fit content - Adjusts the column width to accommodate its content without wrapping. If the content is wider than the table, the table is extended to multiple pages.
Fit content one table area per page - Adjusts the column width to accommodate its content without wrapping, and breaks each column onto its own page.
Fit content to page - Adjusts the column width to accommodate its content without wrapping, and stretches the last column to fill the page.
Equal width columns - Each column receives the same width to fit across a single page.
User specified layout - Enables you to enter a numeral that represents a percentage of the overall page width. You can set a percentage for each column that totals 100%, or enter a percentage for one column, and the others selected receive an even percentage of the space remaining.

The Display Options area provides format options for each individual data column. This enables you to set different font style, size, and color and column background colors for each data column. To activate the display options, select one or more data columns:

To select one column: click the column by its Field name.
To select one or more contiguous columns: click a field, hold down the Shift key, and select the remaining fields.

To select one or more non-contiguous columns: click a field, hold down the Ctrl key and select the remaining fields

Attribute	Description
Font	From the drop-down menu, choose a font for the selected columns.
Foreground Color	Foreground color for text, any visible lines that describe rows/columns, and other elements in the foreground.
Background Color	Background (field) color for the data column.

In the Global Options area, you can set formatting options that apply to the whole table (not just one column).

Attribute	Description
Merge cells	Indicates whether to merge cells for grouped columns. When this option is enabled, identical values in grouped columns show only once. When this option is disabled, identical values show as many times as they are occur (regardless of whether they are grouped).
Show group header	Indicates whether to show a group header row. This is a group label for when you have a summary function that adds one more rows at the end of the section. If this option is enabled, the table includes an extra column with a header derived from the content by which the section is grouped.
Show group columns	Enable this option to populate the grouped columns with data. (If this option is disabled, grouped columns are empty.)
Grand total	If you want to provide a grand total of all the sections, check the Show grand total box.
Label	If you selected a grand total, you can apply a label for the grand total. For example, use Total VPN Login Attempts.

Click the Preview button to preview the report table with the current configuration.