Element Details: Analysis+Grid+Column
 Back


Available in: Logi Info Source code name: AnalysisGridColumn

Analysis Grid Columns define the data columns that may be displayed and manipulated in the Analysis Grid.

There are special values available for the Format attribute. "Bars" displays values with the CellBar element. "BackgroundColorSlider" displays values with the CellColorSlider element.

For date columns, the AnalysisGrid is designed to work with the browser's culture. The default format is "Short Date". This displays and gets dates with year, month and day in the appropriate regional order. Do not set the Format attribute to a fixed d-m-y or m-d-y order.

AnalysisGrids support resizable columns. If setting the Width for a column, specify pixels.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
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.
ColumnVisible
True
False
For the AnalysisGrid, indicates if a column is initially visible. The user can make the column visible from the Layout panel. The default value is True.
DataColumn
UserDefined
(Required) The name of a data field/column returned from the DataLayer.
DataType
Text
Number
DateTime
Date
Boolean
(Required) Specifies the type of data present.
Format
UserDefined
Allows a string to be formatted in various ways, especially for numeric and date values. Specifies formatting characteristics for the data. This attribute has been borrowed from the Microsoft Visual Basic Format function. For more information: http://msdn.microsoft.com/en-us/library/59bz1f0h(VS.71).aspx For dates, the non-specific formats, such as "General Date", "Short Time", etc., are converted according to the browser's international setttings. Also, for very large reports, the non-specific formats perform better. There are also some special formats. "<" and ">" change strings to lower and upper case. "Expanded Spaces" preserves space characters that would otherwise be collapsed by the web browser. "HTML" preserves HTML tags so that they are not encoded - they are embedded rather than shown. "Preserve Line Feeds" preserves line feed and cariage return characters so that the following characters appear on a new line. "mp" formats numbers with the "metric prefix". To format 1,234,567 as "$1.23M", use Format "$#.00mp". Supported metric prefixes are from 1000^6 to 1000^-6 For more information: http://en.wikipedia.org/wiki/Metric_prefix "mpsx" formats the value with x number of significant figures in addition to the metric prefix. So a value of 123456, with format set to mps3 will return 123k. "qq" returns the number of the quarter when the value being formatted represents a date. To return the year and quarter together like "2010 Q1", set the format to "yyyy Qqq". "fyy" and "fyyyy" return the fiscal year. "fqq" returns the fiscal quarter. The fiscal year start date may be configured in the settings' Globalization element. "ww" returns the number of the week. The first day of the week may be configured in the settings' Globalization element.
Header
UserDefined
(Required) The column's heading. In special cases in which an extra HeaderRow element is used to make grouped column headings, and one of its columns has a RowSpan greater than 1, the column header's Caption may be set to "None". This prevents the header column from getting created and thus pushing other column headers into the wrong positions.
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.
NoAgAggregates
True
False
Set to True to prevent this column from being used as an aggregate column. The user will not be able to pick the column from the drop-down list.
NoAgCrosstabAggregate
True
False
Set to True to prevent this column from being used as a Crosstab Aggregate column. The user will not be able to pick the column from the drop-down list.
NoAgCrosstabHeader
True
False
Set to True to prevent this column from being used as a Crosstab Header or Label column. The user will not be able to pick the column from the drop-down list. When either the NoCrosstabHeader or NoCrosstabLabel attribute is set, the column is excluded from both Headers and Labels. In general, Crosstab Header columns should have a limited number of possible values, and multiple rows will share the same values.
NoAgCrosstabLabel
True
False
Set to True to prevent this column from being used as a Crosstab Label column. The user will not be able to pick the column from the drop-down list. When either the NoCrosstabHeader or NoCrosstabLabel attribute is set, the column is excluded from both Headers and Labels. In general, Crosstab Label columns should have a limited number of possible values, and multiple rows will share the same values.
NoAgFilter
True
False
Set to True to prevent this column from being used as a Filter column. The user will not be able to pick the column from the drop-down list.
NoAgFormatting
True
False
Set to True to prevent this column from being formatted.
NoAgGrouping
True
False
Set to True to prevent this column from being used as a grouping column. The user will not be able to pick the column from the drop-down list.
NoSorting
True
False
Set to True to prevent this column from being Sorted. The user will not be able to select this column in the Sort Panel or sort the column with the column header.
PopupValuesForFilter
List
Calendar
Allows the user to select from a list of values. When "List", a link appears next to the Value field when the user is working in the Filter panel. The link displays a popup panel listing all the distinct values for the column. A value can be clicked, putting it into the Value field. When "Calendar", the link displays a popup panel with a calendar, allowing the user to select a date for the filter Value.
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.
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.

Analysis Grid


CHILD ELEMENTS

Click element to drill down for more information.

Action.Exit
Action.Export CSV
Action.Export Native Excel
Action.Export Native Word
Action.Export PDF
Action.Export Word Or Excel
Action.Google Spreadsheet
Action.Javascript
Action.Link
Action.Map Location
Action.Popup Menu
Action.Process
Action.Report
Action.Template
Conditional Class
Excel Column Format


 Back to top


 Chart Debug