<< Click to Display Table of Contents >> Navigation:  Professional > Reports > Crosstab Reports > Column Headers and Row Headers

•Add Column Headers and Row Headers

•Set Header Properties

oCaption

oAggregate (Row Header(s) property only)

oSort

oDisplay

oDisplay (Non-Detect)

oHide

 

Column Headers are additional rows of values related to the cross-tabbed fields visible across the top of the final Crosstab Report (i.e. the column headers).  

 

Row Headers are additional columns of values related to the cross-tabbed fields visible on the left of the final Crosstab report.

 

Add Column Headers and Row Headers

 

To select Column Headers or Row Headers, drag and drop the desired field(s) from the list of Available Columns list located on the right side of the Crosstab screen onto the Column Headers or Row Headers grid section. The Available Columns vary based on the report that the Crosstab is created from. (The additional Available Columns for an Action Level Exceedance Report are explained here.)

 

 

For example, create a Crosstab Report that includes location and date information in the Column Headers across the top of the Crosstab. Specify column header(s) by dragging the corresponding field(s) from the list of Available Columns and dropping the field(s) onto the Column Header(s) grid. In this example, drag SYS_LOC_CODE and SAMPLE_DATE and drop them onto the Column Header(s) grid.

 

 

 

Reorder Fields

 

To reorder fields after they have been placed in the Column Headers or Row Headers grid, drag and drop the fields into the desired order.

 

Remove/Delete Fields

 

To remove or delete rows from the Column Header(s) section, select the row(s) that you want to remove and then press the Delete key. Then press YES on the delete confirmation.

 

Selecting Multiple Fields

 

You can select multiple rows in a grid section by using the CTRL or SHIFT keys for Drag/Drop, Reordering, and Deleting actions. Dragging and dropping multiple fields is only supported from the Available Columns list. It is not yet supported from either the Column Header(s) or Row Header(s) sections.  

 

 

Set Header Properties

 

Column or Row Headers have the following properties:

•Caption

•Aggregate (Row Header only; see also Tabbed Data or full details at Aggregate Feature)

•Sort

•Display

•Hide

 

Caption

 

The Caption property defines the display text shown for this field's label. This is useful if you do not want to use the actual field name as the caption. For example, you can enter "Location" into the Caption property to use that caption in the final report, instead of SYS_LOC_CODE. If null, the default text that is displayed is the Column (Field) name.

 

   

 

Aggregate (Row Header(s) property only)

 

You can set Row Header(s) to display an aggregate calculation for all aggregate values in the Tabbed Data section.

 

 

Sort

 

All Column and Row Headers will default to be sorted first in ascending order, according to the order in which they appear in their respective header section. This is needed for the base crosstabbing functionality. In order to set sorting priority on selected fields, the Sort Column allows the specification of how the headers should be sorted ("Asc" for Ascending, or "Desc" for Descending). Headers set with a specified sort will be sorted first, according to the specified sort order (ascending, descending), before other columns that have not been set to an explicit sorting. The resulting crosstab columns to the right of the Row Header(s) output columns will be sorted according to the Column Header(s) sorting properties. The resulting crosstab rows will be sorted according to the Row Header(s) sorting properties.

 

 

 

Display

 

The Display column lets you specify how the column will be displayed in the final report with the following options:

•Default: Generic, non-specialized view of data

•Merge (Column Header(s) only): Columns headers containing the same value will be merged (horizontally) when exported to Excel. The merging of cells only occurs on export and will not apply to the grid in EQuIS Professional.

•Group By (Row Header(s) only): The group by option will group all rows in the Crosstab by every distinct value of the specified row header. These groupings will be displayed in the Crosstab grid output in Professional and in the exported Crosstab documents. When one of the Group By options is selected, all rows with the same value for the selected report field and will be preceded by a separator row displaying the value the rows have been grouped by. Additionally, you can select "Group By (Sum)" and "Group By (Avg)". Selecting either of these will add a Sum or Average of the tabbed data values at the end of the grouped by section.

•Exceedance (bold): Bolds exceedances

•Exceedance (italic): Italicizes exceedances

•Exceedance (underline): Underlines exceedances

•Exceedance (custom): Customize this option to display exceedances in a unique manner.

 
             

 

Display (Non-Detect)

 

The Display (Non-Detect) column is used to define the displaying formats for non-detect exceedances and has the following options:

•Default: non-detect exceedances take the exceedances formats defined by Display.

•Exceedance (bold): Bolds exceedances of non-detects

•Exceedance (italic): Italicizes exceedances of non-detects

•Exceedance (underline): Underlines exceedances of non-detects

•Exceedance (custom): Customize this option to display exceedances of non-detects in a unique manner.

 

 

 

Hide

 

The Hide check box lets you specify whether or not the column will actually be displayed in the final report. In some cases, it may be necessary to include a value for sorting or Detection formatting purposes but not have the value actually displayed in the report. In that case, check the Hide check box.