Element Details: Sql+Crosstab
 Back


Available in: Logi Info Source code name: SqlCrosstab

The ActiveSQL SqlCrosstab converts the Data Layer into a "cross-tab" format.

SqlCrosstabs are used exclusively with the CrosstabTable.

To create a SqlCrosstab, you must specify a CrosstabColumn, a LabelColumn, a ValueColumn, and a ValueFunction. These come from the results of the DataLayer. The CrosstabColumn creates a column for each distinct value. Each row is represented by the distinct values in the LabelColumn. The "cells" are derived from the ValueColumn by adding, counting, or averaging (depending on the Value Function) all the values unique to each Crosstab and Label Column.

Element Group:Organize Data



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CrosstabColumn
UserDefined
(Required) Specifies a column name returned in the DataLayer. Each distinct value adds a new column to the DataLayer.
CrosstabLabelColumn
UserDefined
(Required) Specifies a column name returned in the DataLayer. Each distinct label value adds a new row to the crosstabbed DataLayer. Display the column in a Crosstab Table with "@Data.ColumnName~", where ColumnName is the name of the column.
CrosstabValueColumn
UserDefined
(Required) Specifies a column name returned in the DataLayer. The column should contain values which are aggregated into each cell of the table.
CrosstabValueFunction
Sum
Stdev
Count
Average
(Required) Specifies how values are calculated into the Value Column. For the CrosstabFilter element, the "Any" function displays a value from any of the input rows. This may be used when the CrosstabValueColumn is a string that is not appropriate for aggregation, especially when there is one record to represent each crosstab cell.
ID
UserDefined
The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
MaxCrosstabColumns
UserDefined
Sets the maximum number of crosstab columns returned by the Crosstab Filter. A column is created for each distinct value of the Crosstab Column. In some cases this number should be limited so that the table does not become too wide. The default Max Crosstab Columns is 100.
MaxCrosstabRows
UserDefined
Sets the maximum number of crosstab rows returned by the Crosstab Filter. In some cases this number should be limited so that the table does not become too large in memory. Defaults to 10,000 rows.



PARENT ELEMENTS

Click element to drill down for more information.



CHILD ELEMENTS

Click element to drill down for more information.



 Back to top