Tabbed Data

<< Click to Display Table of Contents >>

Navigation:  Professional > Reports > Crosstab Reports >

Tabbed Data

The Tabbed Data represents the values to be shown in the body of the final report. Specify tabbed data by dragging the corresponding field(s) from the list of Available Columns and dropping the field(s) onto the Tabbed Data grid. Reorder row headers within the Tabbed Data grid by dragging and dropping fields within the grid.

 

In the example, to show the result and the qualifier, drag the REPORT_RESULT_TEXT and INTERPRETED_QUALIFIERS fields from the Available Column(s) grid onto the Tabbed Data grid.

 

Tabbed Data Options

Tabbed Data Options

 

The following Result fields are listed in the Available Columns and are defined by the following.

 

Result Field Columns

Definition

REPORT_RESULT_VALUE

This field includes converted numeric results based on unit selections made in the Report parameter screen.

REPORT_RESULT_TEXT

This field includes converted text results (preserving non-numeric symbols and significant figures) based on unit selections made in the Report parameter screen.

Result Numeric

This field includes the original numeric results as they appear in DT_RESULT.

Result Text

This field includes the original text results (preserving non-numeric symbols and significant figures from DT_RESULT.

 

After adding the tabbed data, it is possible to specify some additional options.

 

The Caption column allows the specification of a caption that should be used for this value in the final report. If not specified, the default value is the Column (Field) name.

 

The Aggregate option is highly applicable to the results tab. The data can be aggregated as described on the Aggregate Feature page.

 

The Referenced Aggregate option allows the user to perform an aggregate based on another aggregate. Specifying a different field name here along with an Aggregate option selection will result in this column displaying values for this field that match the specified aggregate calculation.

 

Read more on the use of the Aggregate and Referenced Aggregate features.

 

The Format option allows the user to include text to Tabbed Data. Incorporate the value in specified text where '{0}' represents the value. For example, in the Format field, add the value '--'. This will place the desired text into the crosstab results.

 

Added '--' text for Values After the Report Value

Added '--' text for Values After the Report Value

 

Note: The "Format" will not be applied if an Aggregate has also been applied to this Tabbed Data field.

 

The Null option replaces any null/empty values with the input value. For example, in the NULL field, add the text NA and all null cells in the crosstab will be replaced with the text NA.

 

15413-CrosstabNull