Report |
public class ReportModel : ReportComponent
The ReportModel type exposes the following members.
Name | Description | |
---|---|---|
ReportModel | Initializes a new instance of the ReportModel class |
Name | Description | |
---|---|---|
AggregateRestriction | The aggregate restriction text of the model | |
AggregateRestrictions | List of aggregate restrictions of the model | |
Alias | Alias name used for the table defining the select | |
AllExecutionRestrictions | List of all restrictions of the model (including aggregate and common restrictions) | |
BuildTimeout | Timeout in milliseconds to set the maximum duration used to build the SQL (may be used if many joins are defined) | |
CommandTimeout | "Default Timeout in seconds for the SQL Statements executed to load the model. -1 means the use of the Timeout defined in the connection. 0 means no Timeout. | |
CommonRestrictions | List of common restrictions and values involved in the model. Common Restrictions or Values are defined in the SQL (Pre, Post, Table SQL, Where Clause, etc.) with the '{CommonRestriction_' or '{CommonValue_' keywords (e.g. {CommonRestriction_Amount} to create a common restriction named 'Amount') | |
Connection | The current MetaConnection of the model | |
ConnectionGUID | The connection used to build the model | |
Elements | Elements selected for the model | |
ExecutionAggregateRestrictions | List of aggregate restrictions of the model | |
ExecutionCommonRestrictions | List of Common Restrictions of the model | |
ExecutionRestrictions | List of restrictions of the model | |
ExecutionSet | During the models generation, the models of the same Set Number are generated in parallel at the same time. The models with Set 1 are executed first at the same time, then models with Set 2, etc. This can be used if models depends on other models. | |
FinalScript | Optional Razor Script to modify the model after its generation | |
FromTables | List of tables involved in the model | |
GUID |
The unique identifier
(Inherited from RootComponent) | |
HasCellScript | True if the model has cell script defined for one of its element | |
HasChartJSSerie | True if the model has a Chart JS serie | |
HasEmptyRepeated | True if the model has elements with EmptyRepeated | |
HasNVD3Serie | True if the model has a NVD3 serie | |
HasPlotlySerie | True if the model has a Plotly serie | |
HasPrimaryYAxis | True if the model has a primary axis for a serie | |
HasScottPlotSerie | True if the model has a Chart ScottPlot serie | |
HasSecondaryYAxis | True if the model has a secondary axis for a serie | |
HasSerie | True if the model has series defined | |
HasStandardAggregateRestrictions | Return true if the aggregate restrictions are standards (simple list with AND) | |
HasStandardRestrictions | Return true if the restrictions are standards (simple list with AND) | |
HasSubTotals | True if the model has subtotals | |
HasTotals | True if the model has totals | |
HelperViewJoins | Helper to view joins evaluated for the model | |
IgnorePrePostError | If true, errors occuring during the Pre or Post SQL statements are ignored and the execution continues | |
IsLINQ | True is it is a Model based on a LINQ source | |
IsSQLModel | True is it is a SQL Model (not standard based on the metadata) | |
IsSubModel | True is it is a Sub-Model used for a LINQ Query | |
JoinsToSelect | Helper to select Join preferences | |
JoinsToUse | List of Joins used to perform the query and joins the tables involved. By default, all Joins available in the Data Source are used. | |
KeepColNames | If true, the column names of the source a kept when building the metadata columns | |
LINQLoadScript | Default LINQ Load Script used for the model | |
LINQQueryScript | If not empty, overwrites default query script template used to generate the LINQ query | |
LINQSubModels | List of SQL Sub-models involved in a LINQ Model | |
LINQSubTables | List of SQL Sub-tables involved in a LINQ Model | |
LoadScript | The Razor Script used to load the data in the table. If empty, the load script defined in the master table is used. | |
MaxNumberOfRecords | Limit the number of records loaded for the model. A value of 0 means no limitation. The implementation at server side is only done for MS SQLServer, Oracle and MYSQL | |
Name |
The name
(Inherited from RootComponent) | |
PostSQL | SQL Statement executed after the main query. The statement may contain Razor script if it starts with '@'. | |
PreLoadScript | Optional Razor Script to modify the result table of the model just before the database load | |
PreSQL | SQL Statement executed before the main query. The statement may contain Razor script if it starts with '@'. | |
PrintQuery | If true, the query is printed in the report messages (for debug purpose). | |
ReferenceModel | Current reference model if any | |
ReferenceModelGUID | If set, restrictions and elements from the referenced model are inserted to the current model. This enables the sharing of restrictions and elements among different models. The position of the element inserted can be specified in the element property 'Insert position' in the referenced model. | |
Report |
The current report
(Inherited from ReportComponent) | |
Restriction | The restriction text of the model | |
Restrictions | List of restrictions of the model | |
ResultTableTranslated | Result DataTable got from the SQL query with the original column names and without hidden columns | |
SerializedTag | Custom string serialized (saved with the report definition) | |
SerializedTag2 | Custom string serialized (saved with the report definition) | |
ShareResultTable | If true and several models have the same SQL or Script definiton, one result table is generated and shared for those models (Optimization). | |
ShowFirstLine | If true and the table has column values, the first line used for titles is generated in the table header | |
Source | Current report source | |
SourceGUID | The source used to build the model | |
Sql | SELECT Sql used for the model | |
SqlCTE | If not empty, overwrite the CTE (Common Table Expressions) clause in the generated SQL statement | |
SqlFrom | If not empty, overwrite the FROM clause in the generated SQL statement | |
SqlGroupBy | If not empty, overwrite the GROUP BY clause in the generated SQL statement | |
SqlOrderBy | If not empty, overwrite the ORDER BY clause in the generated SQL statement | |
SqlSelect | If not empty, overwrite the SELECT clause in the generated SQL statement (e.g 'SELECT TOP 10', 'SELECT') | |
SubModelsSetAggr | If true, aggregates are copied to sub-models elements, otherwise the sub-models elements have no aggregate. This may impact the final performances and results (especially for Count or Average aggregates). | |
SubModelsSetRestr | If true, restrictions and theirs values defined for the LINQ model are automatically copied to the sub-models. | |
Table | Table definition for a SQL Model | |
UseRawSQL | If true, the raw source SQL is used to generate the result table instead of using a 'select * from (Source SQL) a' statement. In this case, aggregations, restrictions and custom SQL are not applied | |
UseSelectDistinct | If true, SELECT DISTINCT clause clause is used by default for the model if no aggregate is defined |
Name | Description | |
---|---|---|
BuildQuery | Build the SQL for the model | |
CancelCommand | Cancel the model execution | |
CheckChartJSIntegrity | Check ChartJS and set the ExecChartJSType property | |
CheckNVD3ChartIntegrity | Check NVD3 Chart and set the ExecNVD3ChartType property | |
CheckPlotlyChartIntegrity | Check Plotly Chart and set the ExecPlotlyChartType property | |
CheckScottPlotChartIntegrity | Check ScottPlot and set the ExecScottPlotChartType property | |
CheckSortOrders | Force sort orders on Page elements | |
ClearCommonRestrictions | Clear Common Restrictions from a SQL | |
ClearLostElements | Delete elements and restrictions with no source reference | |
Create | Creates a default report model | |
EnumDisplayValue | Translate the enum using the Enum context | |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) | |
ExecuteLoadScript | Execute custom Razor script for the model: Pre Load, Post Load and Final | |
FillResultTableAsync | Build the ResultTable for the model | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) | |
GetElements | List of elements per position | |
GetHashCode | Serves as the default hash function. (Inherited from Object) | |
GetNavigation | HTML Navigation for the report result | |
GetRestrictionByName | Returns a model restriction from its name | |
GetResultTableValue | Return a result table value from a column name | |
GetSplitterElements | List of splitter elements per axis type | |
GetType | Gets the Type of the current instance. (Inherited from Object) | |
GetXElements | List of elements per type of axis | |
Init |
Init the editor objects
(Inherited from RootEditor) | |
InitCommonRestrictions | Init all Common Restrictions of the model and build the CommonRestrictions property | |
InitDefaultValues |
Init the default values
(Inherited from RootEditor) | |
InitEditor |
Init the editor objects and the default values
(Inherited from RootEditor) | |
InitFromReferenceModel | Initializes the model its reference model | |
InitReferences | Init all model references: Elements, Restrictions, etc. | |
InvertDataTables | Invert the rows and the columns of all DataTables of the pages generated | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) | |
ParseCommonRestrictions | Parse and replace Common Restrictions in SQL by their values | |
RefreshMetaTable | Initialize the MetaTable for a SQL Model | |
SetColumnsName | Set column names for the elements before building the SQL | |
SetReadOnly |
Set all properties to readonly
(Inherited from RootEditor) | |
ShouldSerializeCommandTimeout | ||
ShouldSerializeLINQSubModels | ||
ShouldSerializeLINQSubTables | ||
ShouldSerializeMaxNumberOfRecords | ||
ShouldSerializePrintQuery | ||
ShouldSerializeReferenceModelGUID | ||
ShouldSerializeShareResultTable | ||
ShouldSerializeShowFirstLine | ||
ShouldSerializeSubModelsSetAggr | ||
ShouldSerializeSubModelsSetRestr | ||
ShouldSerializeUseSelectDistinct | ||
ToString | Returns a string that represents the current object. (Inherited from Object) | |
UpdateEditor |
Update editor attributes
(Inherited from RootEditor) | |
UpdateEditorAttributes |
Refresh properties attrivutes
(Inherited from RootEditor) | |
UpdateFinalSortOrders | Update the final sort orders |
Name | Description | |
---|---|---|
_connectionGUID | ||
_dctd | (Inherited from RootEditor) | |
_GUID | (Inherited from RootComponent) | |
_name | (Inherited from RootComponent) | |
_report | (Inherited from ReportComponent) | |
DefaultLINQScriptTemplate | ||
ExecAxisPrimaryYIsDateTime | True if chart primary axis is date time | |
ExecAxisSecondaryYIsDateTime | True if chart secondary axis is date time | |
ExecChartIsDateTimeAxis | True if chart is date time axis | |
ExecChartIsNumericAxis | True if chart is numeric axis | |
ExecChartJSType | Chart JS type | |
execCTEClause | CTE Clause generated at execution | |
ExecD3PrimaryYAxisFormat | Format for D3 primary chart axis | |
ExecD3SecondaryYAxisFormat | Format for D3 secondary chart axis | |
ExecD3XAxisFormat | Format for D3 chart X axis | |
execFromClause | FROM Clause generated at execution | |
execGroupByClause | GROUP BY Clause generated at execution | |
execHavingClause | HAVING Clause generated at execution | |
ExecMomentJSXAxisFormat | Format for Moment JS chart X axis | |
ExecNVD3ChartType | NVD3 chart type | |
execOrderByClause | ORDER BY Clause generated at execution | |
execOrderByNameClause | ORDER BY NAME Clause generated at execution (used for No SQL Source) | |
ExecPlotlyChartType | Plotly chart type | |
ExecResultPagesBuilt | True if the result pages have been built | |
ExecResultTableLoaded | True if the source result table has been loaded | |
ExecResultTables | Current list of result tables for the model execution | |
execSelect | Full SQL Select generated at execution | |
execSelectClause | SELECT Clause generated at execution | |
ExecTableJoins | Current list of tables used for the join | |
ExecutionDate | Execution date of the model | |
ExecutionDuration | Execution duration of the model | |
ExecutionError | Error messages during execution | |
execWhereClause | WHERE Clause generated at execution | |
JoinPaths | Description of the joins chosen to build the SQL | |
LINQSelect | LINQ SELECT used for the model | |
MasterModel | Master model if the model is a sub-model for LINQ source | |
Pages | List of Pages generated after the model execution (one page per Page element values) | |
Progression | Progression in percentage of the model processing | |
RestrictionText | Display text for the restrictions of the model | |
ResultTable | Result DataTable got from the SQL query | |
SummaryTable | Summary Table generated after the model execution (only if Page element are defined in the model) | |
Tag | Custom Tag the can be used at execution time to store any object | |
Tag2 | Custom Tag the can be used at execution time to store any object | |
Tag3 | Custom Tag the can be used at execution time to store any object |