Table of Contents

Table Sys_Reports

Entity

Entity: Systems.Core.Reports

User-defined reports. Reports retrieve data from data sources and present it in a user-defined layout. Entity: Sys_Reports

Summary

Name Type Description
Data_Source_Id uniqueidentifier Report data source. If specified should be based on the query in Query_Name. NULL means that the report is based directly on the query
Layout_Format nvarchar(32) Format specifier of the layout. Recognized by the application
Notes nvarchar(512)
One_Row bit True means that report can be used for one-row forms only. False means that the report can be used for navigators only.
Query_Name nvarchar(128) The query on which the report is based
Report_Binary_Layout varbinary The printout layout, when the format requires binary storage. Alternative to Report_Layout
Report_Id uniqueidentifier PK
Report_Layout nvarchar(max) The textual representation of the printout layout, when the format requires text representation. Alternative to Report_Binary_Layout
Report_Name nvarchar(254) Multi-language report name
Row_Version timestamp
Template_Filter_Xml nvarchar(max) Specifies the filter condition, which must be satisfied in order for this report to be prioritized for printing as a template sub-report. NULL when the current report cannot be used as template sub-report.
Template_Priority int Specifies the priority of the current report, relative to other reports. Used only when choosing which report to show as a template subreport, NULL otherwise.

Columns

Data_Source_Id

Report data source. If specified should be based on the query in Query_Name. NULL means that the report is based directly on the query

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sys_Data_Sources
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Data_Source_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Layout_Format

Format specifier of the layout. Recognized by the application

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 32
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type nvarchar(32) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Layout_Format - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Notes

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 512
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(512) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

One_Row

True means that report can be used for one-row forms only. False means that the report can be used for navigators only.

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

One_Row - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Query_Name

The query on which the report is based

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 128
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(128)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Query_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Report_Binary_Layout

The printout layout, when the format requires binary storage. Alternative to Report_Layout

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type varbinary (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Report_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Report_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes

Report_Layout

The textual representation of the printout layout, when the format requires text representation. Alternative to Report_Binary_Layout

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Report_Name

Multi-language report name

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 254
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254)
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Report_Name - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes
Like None no no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Template_Filter_Xml

Specifies the filter condition, which must be satisfied in order for this report to be prioritized for printing as a template sub-report. NULL when the current report cannot be used as template sub-report.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Template_Priority

Specifies the priority of the current report, relative to other reports. Used only when choosing which report to show as a template subreport, NULL otherwise.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type int (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes
Suggest improvement to this page