Search Results for

    Show / Hide Table of Contents

    Namespace LemonEdge.API.Entities.Reporting

    Classes

    Chart

    DataTemplate

    DataTemplateAttachment

    Dataset

    DatasetQueryableItem

    DatasetQueryableItemFieldInfo

    DatasetQueryableItemJoin

    DatasetShortcut

    DatasetShortcutOverride

    DevExpressReport

    ExpressReport

    ExpressReportDataSet

    ExpressReportDataSetParameter

    ExpressReportExportFormatHelper

    ExpressReportRelationship

    ExpressReportRelationshipColumn

    FilterDescriptor

    Pivot

    PivotFieldInfo

    QueryRunner

    QueryRunnerStep

    QueryRunnerStepParameter

    Report

    ReportDevExpressHelper

    SQLAssembly

    SQLFunction

    SQLTypeWrapper

    SQLWrapper

    SQLWrapperChain

    SQLWrapperChainLink

    SQLWrapperDependant

    SQLWrapperResult

    SQLWrapperStat

    SSRSReport

    SSRSReportExportFormatHelper

    Helps with the various ssrs report file types

    VennSet

    VennSetQueryableItem

    VennSetQueryableItemFieldInfo

    VennSetQueryableItemParam

    Interfaces

    IChart

    The system entity for a Chart, which is displays data from a IPivot and in turn a ISQLWrapper

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/charts/intro.html for more information

    IDataTemplate

    The system entity for data templates which can be used when exporting data into excel

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/data-templates/intro.html for more information

    IDataTemplateAttachment

    The system entity for a Template Attachment, which holds the file to use as a template for the exported data

    See https://help.lemonedge.com/excel-templates/ for more information

    IDataset

    The system entity for a DataSet, which is used for dynamically creating reports for use throughout the system

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/intro.html for more information

    IDatasetQueryableItem

    The system entity for a DataSet Queryable Item, which belongs to a IDataset

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/queryable-items-view.html for more information

    IDatasetQueryableItemFieldInfo

    The system entity for a DataSet Queryable Item field, which belongs to a IDataset and IDatasetQueryableItem

    This ties a field from a queryable item to its definition in a ISQLTypeWrapper against the SQL Wrapper for this dataset. This way the system knows which queryable item field should be described by which result column in the sql

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/columns-view.html for more information

    IDatasetQueryableItemJoin

    The system entity for a DataSet Queryable Item Join, which belongs to a IDataset and IDatasetQueryableItem

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/queryable-items-view.html for more information

    IDatasetShortcut

    The system entity for a query shortcut, which is used for dynamically enhancing datasets

    IDatasetShortcutOverride

    IFilterDescriptor

    The system entity for filter descriptors, which is used in IDataset filters, and other system filters

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/datasets/where-filters-view.html for more information

    IPivot

    The system entity for a pivot entity, which is capable of taking any sql wrapper of data and pivotting it dynamically

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/pivots/intro.html for more information

    IPivotFieldInfo

    The system entity for a pivot field info entity, which belongs to a pivot definition

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/pivots/design-view.html for more information

    IQueryRunner

    The system entity for a Query Runner, which allows each result of a query to be run against a QueryRunHandler

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/query-runners/intro.html for more information

    IQueryRunnerStep

    The system entity for a Query Runner Step, which takes the result of a IQueryRunner and processes it

    See https://help.lemonedge.com/query-runners/ for more information

    IQueryRunnerStepParameter

    The system entity for a Query Runner Step Parameter, which provides the parameter value for the IQueryRunnerStep

    See https://help.lemonedge.com/query-runners/ for more information

    IReport

    The system entity for a base report. This is the main report base. All report entities inherit from this

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/intro.html for more information

    IReportBase

    Any LemonEdge entity interface that inherits this, means it is acquires all the functionality of a report and can be used in IQueryRunner

    See https://help.lemonedge.com/reports/ for more info

    IReportDevExpress

    The system entity for a dev express report

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information

    IReportExpress

    The system entity for an express report

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information

    IReportExpressDataSet

    The system entity for an express report data

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information

    IReportExpressDataSetParameter

    The system entity for an express report data parameters

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information

    IReportExpressRelationship

    The system entity for an express report relationship

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information

    IReportExpressRelationshipColumn

    The system entity for an express report relationship column

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/express.html for more information

    IReportSSRS

    The system entity for a ssrs report

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/reports/ssrs.html for more information

    ISQLAssembly

    The system entity for clr sql assemblies which can be used in IDataset and ISQLWrapper sql

    See https://help.lemonedge.com/help/settings/enterprise-tools/sql-functions/intro.html for more information

    See https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration-database-objects-user-defined-functions/clr-user-defined-aggregate-invoking-functions?view=sql-server-ver15 for information about sql clr functions

    ISQLFunction

    The system entity for clr sql functions which can be used in IDataset and ISQLWrapper sql

    See https://help.lemonedge.com/help/settings/enterprise-tools/sql-functions/intro.html for more information

    See https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration-database-objects-user-defined-functions/clr-user-defined-aggregate-invoking-functions?view=sql-server-ver15 for information about sql clr functions

    ISQLTypeWrapper

    The system entity for a sql type wrapper, which indicates the parameters and columns of the parent sql wrapper it belongs to

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/sql-wrappers/columns.html and https://help.lemonedge.com/help/enterprise-data-tools/reporting/sql-wrappers/parameters.html for more information

    ISQLWrapper

    The system entity for a sql wrapper, which wraps custom (or system generated) sql and defines its schema both of parameters and results for integration and use with our query tools

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/sql-wrappers/intro.html for more information

    ISQLWrapperChain

    ISQLWrapperChainLink

    ISQLWrapperDependant

    ISQLWrapperResult

    The default complex type that can always be used for executing any SQL Wrapper and retrieving the results

    The helper class SQLWrapperInterpretor can be used to evaluate and interrogate the results held in this class

    Any sql wrapper can be executed using GetSQLResults<T>(Guid, string, string)

    ISQLWrapperStat

    IVennSet

    The system entity for a VennSet, which is used for dynamically combining multiple sets of data together

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/intro.html for more information

    IVennSetQueryableItem

    The system entity for a VennSet Queryable Item, which belongs to a IVennSet

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/queryable-items-view.html for more information

    IVennSetQueryableItemFieldInfo

    The system entity for a VennSet Queryable Item field, which belongs to a IVennSet and IVennSetQueryableItem

    This ties a field from a queryable item to its definition in a ISQLTypeWrapper against the SQL Wrapper for this vennset. This way the system knows which queryable item field should be described by which result column in the sql

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/columns-view.html for more information

    IVennSetQueryableItemParam

    The system entity for a VennSet Queryable Item Param, which belongs to a IVennSet and IVennSetQueryableItem

    See https://help.lemonedge.com/help/enterprise-data-tools/reporting/venn-sets/queryable-items-view.html for more information

    IWrapper

    Indicates this item wraps another entity, held by WrappedItem

    This is used for entities that want to display a pivot of options within a grid. The logic for this is all taken care of using this and EntityHasPivotAttribute

    See API.Entities.IGLAccount for an example

    Enums

    ChartCombine

    ChartSeriesFrom

    ChartTotalPosition

    ChartType

    DataSetSetOperatorMethod

    DataTemplateType

    The types of templates that IDataTemplate supports

    DatasetShorcutAvailability

    ExpressReportExportFormat

    FilterLogicalCompositeOperator

    PivotAxis

    PivotFieldDateFormat

    PivotFieldType

    QueryRunnerMergOption

    QueryRunnerStepDocument

    QueryRunnerStepStorage

    SQLFunctionType

    The types of sql functions that ISQLFunction supports

    SQLTypeWrapperType

    SQLWrapperChainType

    SQLWrapperLoadType

    SQLWrapperSQLType

    SQLWrapperType

    SSRSReportExportFormat

    In this article
    Back to top © LemonEdge Technologies. All rights reserved.