Element Details: Crosstab+Table
 Back


Available in: Logi Info Source code name: CrosstabTable

The Crosstab Table creates a "Crosstab" report. Rows are grouped together by some value, with each unique instance spread across the report's columns. The number of columns changes depending on the number of unique values. Crosstab Tables require a Crosstab Filter under the DataLayer. Crosstab Tables may be paginated and sorted. Action elements can define hyperlinks for drill-down reports.

Element Group:Data Tables



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
AccessibleHeaders
True
False
When True, AccessibleHeaders can improve the accessibility/readability of tables by setting HTML "headers" attribute. Default value is False.
AccessibleSummary
UserDefined
The AccessibleSummary attribute may be used to improve web page accessibility for tables. It specifies a summary of the content of a table. The AccessibleSummary attribute has no visual effect in ordinary web browsers, but can be used by screen readers.
AjaxPaging
True
False
Enables AJAX-style paging and sorting. When the user moves to another page, or sorts a column, only the table portion of the page is updated. This method prevents the web page from flickering or losing the scroll position. This alters the behavior of the browser's "Back" button because the page history does not get updated with AJAX Paging. The default value is "False".
AltRowClass
UserDefined
A style sheet class that will be used for every other row of the table. When using in an Analysis Grid define the class as follows in your stylesheet file: TR.[Classname] TD This ensures that your class is not overriden by an AnalysisGrid class. The themes class ThemeAlternatingRow takes care of this for you.
Caption
UserDefined
The Caption attribute identifies the text to be displayed. For Image elements, Caption specifies the image filename.
CaptionClass
UserDefined
For Input elements, this is style sheet class that will be applied to the input element's caption. Leave this value blank unless you want the Caption to have a different class than the input element. For tables, Caption Class sets the class for the table's caption, which appears as a header above the table.
CellSpacing
UserDefined
The width, in pixels, of the space between table cells.
Class
UserDefined
Sets the Cascading Style Sheet class used by the element. When set, this class will also be used by all child elements that don't have their own class. The class should be defined in the report's style sheet file.
ColumnHeaderClass
UserDefined
Sets the class for the table's column headers.
DraggableColumns
True
False
When DraggableColumns="True", the user can reposition columns by dragging the column header side-to-side. The updated column positions are remembered for the table for the current session. You cannot use DraggableColumns when there are custom header rows with columns that span multiple columns. The default value is False.
HideWhenZeroRows
True
False
Removes the DataTable when the DataLayer returns zero rows. The default value is False.
ID
UserDefined
(Required) 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.
Layout
Fixed
Auto
Determines if the table layout is automatic or fixed. The default is automatic. With fixed, the column layout is determined with the first row, instead of adjusting column widths by examining every row. This can help with formatting issues, and can also significantly improve large table performance.
RememberSort
True
False
Remember the user's sort selection. When Remember Sort is True, and the user sorts the Data Table on a particular column, the report will be redisplayed with the same sort order the next time the report is revisited. The sort "memory" applies to the user's current session.
ResizableColumns
True
False
When ResizableColumns="True" and the mouse hovers over the header, an icon appears at the right side of the header. This icon can be dragged left or right to adjust the column width. The updated column widths are remembered for the table for the current session. ResizableColumns may not be used with header rows with columns spanning multiple columns. With ResizeableColumns, when a column's Width attribute is set, it must represent pixels. The default value is False.
SecurityRightID
UserDefined
When entered, access to this element can be controlled with Logi security. Supply the ID of a right defined in the applications settings’ Security element. Only users that have a right in the SecurityRightID will be able to see the element. Note that when rights come from RightFromRole elements under Security/UserRights, and this element's SecurityRightID does NOT match any of the Right IDs defined in the Settings definition, then the user DOES have access. But when Right IDs are instead derived from RightsFromDataLayer or RightsFromRoles elements, and the user DOES NOT have a matching Right, then the user DOES NOT have access. You can enter multiple right IDs, separated by commas. In this case, the user sees the element if he has any one of the Rights.
SortArrows
True
False
Enables sort direction indicators (arrows) when the user clicks a column heading to sort a table. The default value is False
TableBorder
UserDefined
Draws a border around the table. Set this value to the number of pixels of the border width. A value of 1 draws a thin border.
Width
UserDefined
The width of the element.
WidthScale
px
%
The width scale of the element. Value can be "px" for pixels, or "%" for percentage of the available width.



PARENT ELEMENTS

Click element to drill down for more information.

Body
Column Cell
Division
Fieldset Box
HTML Tag
Page Footer
Page Header
Panel Content
Popup Panel
Rectangle
Report Footer
Report Header
Responsive Column
Tab Panel


CHILD ELEMENTS

Click element to drill down for more information.

Append Paging
Conditional Class
Crosstab Comparison
Crosstab Table Label Column
Crosstab Table Value Columns
DataLayer.Bookmarks
DataLayer.Cached
DataLayer.CSV
DataLayer.Definition List
DataLayer.Directory
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.JSON
DataLayer.LDAP
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Mongo Map Reduce
DataLayer.Mongo Run Command
DataLayer.Plugin
DataLayer.REST
DataLayer.Scheduler
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML
Generated Element Plugin Call
Header Row
Interactive Paging
More Info Row
Summary Row


 Back to top


 Chart Debug