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