Report |
The ReportElement type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | AggregateFunction | Aggregate function applied to the Data element |
| AxisUseValues | For Numeric or Date Time axis, if true, the element values are used for the axis, otherwise axis values are linear. This feature does not work for all types of chart. |
| CalculationOption | For numeric Data elements, define calculation option applied on the element in the table |
| Category |
Category used to display the column in the Report Designer tree view. Category hierarchy can be defined using the '/' character (e.g. 'Master/Name1/Name2').
(Inherited from MetaColumn) |
| CellScript | If not empty, the script is executed to calculate custom cell value and CSS |
| ChartJSSerie | Definition of the serie for the element in the Chart JS chart |
| ColumnName |
Returns the SQL column name without prefix
(Inherited from MetaColumn) |
| ContainsHtml | If True, the value contains HTML tags. |
| CssClass |
CSS Classes applied to the cell values of the result HTML Table. Bootstrap classes may be used.
(Inherited from MetaColumn) |
| CssClassEl | CSS Classes applied to the cell values of the result HTML Table. Bootstrap classes may be used. |
| CssStyle |
CSS Styles applied to the cell values of the result HTML Table. Bootstrap classes may be used.
(Inherited from MetaColumn) |
| CssStyleEl | CSS Styles applied to the cell values of the result HTML Table. |
| CssTitle | If True, the CSS Styles and Classes are also applied to the cell titles. |
| DateTimeStandardFormat |
Standard display format applied to the element
(Inherited from MetaColumn) |
| DisplayName |
Name used to display the column in the Report Designer tree view and in the report results
(Inherited from MetaColumn) |
| DisplayName2 |
Display name used to sort the TreeView
(Inherited from MetaColumn) |
| DisplayNameEl | Name of the element when displayed in result tables or restrictions |
| DisplayNameElTranslated | Name of the element translated |
| DisplayNameWithModel | Name of the element with the model name |
| DisplayOrder |
The order number used to sort the column in the tree view (by table and by category)
(Inherited from MetaColumn) |
| DrillChildren |
Defines the child columns to navigate from this column with the drill feature
(Inherited from MetaColumn) |
| DrillUpOnlyIfDD |
If true, Drill Up is activated only if a drill down occured
(Inherited from MetaColumn) |
| EmptyRepeated | IIf true, column values are not repeated if they have the same values. |
| Enum |
Enumerated list if the column has an EnumGUID
(Inherited from MetaColumn) |
| EnumEL | Final enumerated list of the element |
| EnumGUID |
If defined, a list of values is proposed when the column is used for restrictions
(Inherited from MetaColumn) |
| EnumGUIDEL | If defined, the enumerated list is used for the display and for sorting |
| Error |
Last error message
(Inherited from MetaColumn) |
| FinalCssClass | CSS Classes applied to the cell values of the result HTML Table. |
| FinalCssStyle | CSS Style applied to the cell values of the result HTML Table. |
| FinalSort | Final sort as integer (without ASC or DESC) |
| FinalSortOrder | Final sort order of the element |
| ForceAggregate | If Yes, it indicates that the element is an aggregate even it is set in a dimension (Page/Row/Column). By default, the metacolumn flag 'Is aggregate' is used. This flag impacts the build of the GROUP BY Clause. |
| Format |
If not empty, specify the format of the elements values displayed in the result tables (.Net Format Strings)
(Inherited from MetaColumn) |
| FormatEl | Final format of the element |
| FullDisplayName |
Full display name
(Inherited from MetaColumn) |
| GUID |
The unique identifier
(Inherited from RootComponent) |
| HasTime |
True if the column is a DateTime displaying time
(Inherited from MetaColumn) |
| HasTimeEl | True is the element has a time format |
| HelperAddSubReport |
Editor Helper: Add an existing Sub-Report to this column
(Inherited from MetaColumn) |
| HelperCheckColumn |
Editor Helper: Check the column SQL statement in the database
(Inherited from MetaColumn) |
| HelperCreateDrillDates |
Editor Helper: Create automatically a 'Year' column and a 'Month' column to drill down to the date
(Inherited from MetaColumn) |
| HelperCreateEnum |
Editor Helper: Click to create an enumerated list from this table column
(Inherited from MetaColumn) |
| HelperCreateSubReport |
Editor Helper: Create a Sub-Report to display the detail of this table
(Inherited from MetaColumn) |
| HelperOpenSubReportFolder |
Editor Helper: Open the Sub-Report folder in Windows Explorer
(Inherited from MetaColumn) |
| HelperShowValues |
Editor Helper: Show the first 1000 values of the column
(Inherited from MetaColumn) |
| Information |
Last information message ther column has been checked
(Inherited from MetaColumn) |
| InsertPosition | The position in Page, Row, Column, Data of the element inserted if the model is used as a reference model. A value of 0 means to add the element at the end. A negative value can be specified to indicate the position from the last element (e.g. -1 means the position before the last element). |
| IsAggregate |
Must be True if the column contains SQL aggregate functions like SUM,MIN,MAX,COUNT,AVG
(Inherited from MetaColumn) |
| IsAggregateEl | True if the element definition contains already the aggregate |
| IsCommonRestrictionValue | True is the element is a common restriction |
| IsCount | True if the element has a Count or Count Distinct aggregate |
| IsDateTime | True if the element is for Date Time values |
| IsEnum | True if the element has an enumerated list |
| IsNotAggregate | True is the lement is not an aggregate |
| IsNumeric | True if the element is for numeric values |
| IsSerie | True is the element defines a Serie |
| IsSorted | True if the element is sorted |
| IsSQL |
True if the source is a standard SQL source
(Inherited from MetaColumn) |
| IsText | True if the element is for text values |
| LINQColumnName | LINQ Select Column name of the element |
| LINQSelectColumnName | LINQ Select Column name of the element |
| MetaColumn | The MetaColumn of the element |
| MetaColumnGUID | GUID of the MetaColumn of the element |
| MetaEnumValuesEL | List of values of the element enum |
| MetaTable |
Current MetaTable of the column
(Inherited from MetaColumn) |
| Model | Current model |
| Name |
The name of the column in the table or the SQL Statement used for the column
(Inherited from MetaColumn) |
| NavigationScript | Optional Razor Script executed if script navigation links have been added in the CellScript |
| NumericStandardFormat |
Standard display format applied to the element
(Inherited from MetaColumn) |
| Nvd3Serie | Definition of the serie for the element in the NVD3 chart |
| PivotPosition | Position of the element in the Cross Table: Row, Column, Page or Data |
| PlotlySerie | Definition of the serie for the element in the Plotly chart |
| RawDisplayName | Display name of the MetaColumn |
| RawLINQColumnName | LINQ Select Column name of the element |
| RawSQLColumn | SQL of the MetaColumn |
| Report | Current report |
| ScottPlotSerie | Definition of the serie for the element in the Chart JS chart |
| SerieDefinition | Defines how the element is used in the chart. Row or Column elements can be either Axis or Splitter (to create a serie for each splitter value). |
| SerieSortOrder | Defines if the serie is sorted ascending or descending in the chart |
| SerieSortType | Defines how the serie is sorted in the chart |
| SetNullToZero | If Yes, empty cells are set to 0. |
| ShowAllEnums | If Yes, all the values defined in the enumerated list will be shown in the tables, even if the value is not the database Result Set. |
| ShowSubTotals | If true, a line showing sub-totals is added to the main data table when the value of the element changes |
| ShowTotal | For Data elements, add a row or a column showing the total of the element in the table. 'Show only total' means that the columns containing the values of the element will be hidden in the table, only the column containing the total of the element is displayed. |
| SortOrder | Sort order in the result tables. Page elements are sorted first, then Row, Column and Data elements. |
| Source |
Current MetaSource
(Inherited from MetaColumn) |
| SQL | If not empty, overwrite the default SQL or LINQ Expression used for the element in the SELECT statement |
| SQLColumn | Final SQL of the element |
| SQLColumnName | SQL Column name of the element |
| SubReports |
Defines sub-reports to navigate from this column
(Inherited from MetaColumn) |
| Tag |
Tag used to define the security of the Web Report Designer (Columns of the Security Groups defined in the Web Security)
(Inherited from MetaColumn) |
| TotalAggregateFunction | Aggregate function applied for the totals |
| Type | (Inherited from MetaColumn) |
| TypeEd | Data type of the column |
| TypeEl | Final type of the element |
| XAxisType | Not used (FUTURE). Definition of the X axis of the serie (Primary or Secondary). |
| YAxisType | Definition of the Y axis of the serie (Primary or Secondary) |
See Also