Click or drag to resize

ReportModel Properties

The ReportModel type exposes the following members.

Properties
 NameDescription
Public propertyAggregateRestriction The aggregate restriction text of the model
Public propertyAggregateRestrictions List of aggregate restrictions of the model
Public propertyAlias Alias name used for the table defining the select
Public propertyAllExecutionRestrictions List of all restrictions of the model (including aggregate and common restrictions)
Public propertyBuildTimeout Timeout in milliseconds to set the maximum duration used to build the SQL (may be used if many joins are defined)
Public propertyCommandTimeout "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.
Public propertyCommonRestrictions 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')
Public propertyConnection The current MetaConnection of the model
Public propertyConnectionGUID The connection used to build the model
Public propertyElements Elements selected for the model
Public propertyExecutionAggregateRestrictions List of aggregate restrictions of the model
Public propertyExecutionCommonRestrictions List of Common Restrictions of the model
Public propertyExecutionRestrictions List of restrictions of the model
Public propertyExecutionSet 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.
Public propertyFinalScript Optional Razor Script to modify the model after its generation
Public propertyFromTables List of tables involved in the model
Public propertyGUID The unique identifier
(Inherited from RootComponent)
Public propertyHasCellScript True if the model has cell script defined for one of its element
Public propertyHasChartJSSerie True if the model has a Chart JS serie
Public propertyHasEmptyRepeated True if the model has elements with EmptyRepeated
Public propertyHasNVD3Serie True if the model has a NVD3 serie
Public propertyHasPlotlySerie True if the model has a Plotly serie
Public propertyHasPrimaryYAxis True if the model has a primary axis for a serie
Public propertyHasScottPlotSerie True if the model has a Chart ScottPlot serie
Public propertyHasSecondaryYAxis True if the model has a secondary axis for a serie
Public propertyHasSerie True if the model has series defined
Public propertyHasStandardAggregateRestrictions Return true if the aggregate restrictions are standards (simple list with AND)
Public propertyHasStandardRestrictions Return true if the restrictions are standards (simple list with AND)
Public propertyHasSubTotals True if the model has subtotals
Public propertyHasTotals True if the model has totals
Public propertyHelperViewJoins Helper to view joins evaluated for the model
Public propertyIgnorePrePostError If true, errors occuring during the Pre or Post SQL statements are ignored and the execution continues
Public propertyIsLINQ True is it is a Model based on a LINQ source
Public propertyIsSQLModel True is it is a SQL Model (not standard based on the metadata)
Public propertyIsSubModel True is it is a Sub-Model used for a LINQ Query
Public propertyJoinsToSelect Helper to select Join preferences
Public propertyJoinsToUse List of Joins used to perform the query and joins the tables involved. By default, all Joins available in the Data Source are used.
Public propertyKeepColNames If true, the column names of the source a kept when building the metadata columns
Public propertyLINQLoadScript Default LINQ Load Script used for the model
Public propertyLINQQueryScript If not empty, overwrites default query script template used to generate the LINQ query
Public propertyLINQSubModels List of SQL Sub-models involved in a LINQ Model
Public propertyLINQSubTables List of SQL Sub-tables involved in a LINQ Model
Public propertyLoadScript The Razor Script used to load the data in the table. If empty, the load script defined in the master table is used.
Public propertyMaxNumberOfRecords 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
Public propertyName The name
(Inherited from RootComponent)
Public propertyPostSQL SQL Statement executed after the main query. The statement may contain Razor script if it starts with '@'.
Public propertyPreLoadScript Optional Razor Script to modify the result table of the model just before the database load
Public propertyPreSQL SQL Statement executed before the main query. The statement may contain Razor script if it starts with '@'.
Public propertyPrintQuery If true, the query is printed in the report messages (for debug purpose).
Public propertyReferenceModel Current reference model if any
Public propertyReferenceModelGUID 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.
Public propertyReport The current report
(Inherited from ReportComponent)
Public propertyRestriction The restriction text of the model
Public propertyRestrictions List of restrictions of the model
Public propertyResultTableTranslated Result DataTable got from the SQL query with the original column names and without hidden columns
Public propertySerializedTag Custom string serialized (saved with the report definition)
Public propertySerializedTag2 Custom string serialized (saved with the report definition)
Public propertyShareResultTable If true and several models have the same SQL or Script definiton, one result table is generated and shared for those models (Optimization).
Public propertyShowFirstLine If true and the table has column values, the first line used for titles is generated in the table header
Public propertySource Current report source
Public propertySourceGUID The source used to build the model
Public propertySql SELECT Sql used for the model
Public propertySqlCTE If not empty, overwrite the CTE (Common Table Expressions) clause in the generated SQL statement
Public propertySqlFrom If not empty, overwrite the FROM clause in the generated SQL statement
Public propertySqlGroupBy If not empty, overwrite the GROUP BY clause in the generated SQL statement
Public propertySqlOrderBy If not empty, overwrite the ORDER BY clause in the generated SQL statement
Public propertySqlSelect If not empty, overwrite the SELECT clause in the generated SQL statement (e.g 'SELECT TOP 10', 'SELECT')
Public propertySubModelsSetAggr 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).
Public propertySubModelsSetRestr If true, restrictions and theirs values defined for the LINQ model are automatically copied to the sub-models.
Public propertyTable Table definition for a SQL Model
Public propertyUseRawSQL 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
Public propertyUseSelectDistinct If true, SELECT DISTINCT clause clause is used by default for the model if no aggregate is defined
Top
See Also