Table "Report Metadata"
Virtual table that provides metadata information about all reports in the system. This table enables introspection of report properties, layout configurations, and execution characteristics.
Remarks
The Report Metadata table is essential for understanding report definitions and their capabilities. It includes detailed information about report layouts, printing options, data sources, and various behavioral properties that control report execution and output. This table is crucial for report management tools, layout selection, scheduling configuration, and administrative utilities that need to understand report structures and constraints. The information covers all report types including RDLC, Word, Excel, and custom layouts, providing visibility into the reporting infrastructure across all applications.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
| InherentPermissions | rX |
Fields
| Name | Type | Description |
|---|---|---|
| ID | Integer | The unique identifier number of the report. |
| Name | Text[30] | The name of the report as defined in the AL source code. |
| Caption | Text[80] | The caption text displayed for this report in the user interface. |
| UseRequestPage | Boolean | Indicates whether the report displays a request page for parameter input before execution. |
| UseSystemPrinter | Boolean | Indicates whether the report uses the system printer for output operations. |
| EnableExternalImages | Boolean | Indicates whether the report can access and display external images from URLs or file paths. |
| EnableHyperLinks | Boolean | Indicates whether hyperlinks are enabled and functional within the report output. |
| EnableExternalAssemblies | Boolean | Indicates whether the report can use external assemblies for extended functionality. |
| ProcessingOnly | Boolean | Indicates whether the report performs processing only without generating visual output. |
| ShowPrintStatus | Boolean | Indicates whether print status information is displayed during report execution. |
| TransactionType | Option | The transaction type used for database operations during report execution. |
| PaperSourceFirstPage | Integer | The paper source configuration for the first page of the report. |
| PaperSourceDefaultPage | Integer | The paper source configuration for default pages of the report. |
| PaperSourceLastPage | Integer | The paper source configuration for the last page of the report. |
| PreviewMode | Option | The preview mode used when displaying the report before printing. |
| DefaultLayout | Option | The default layout type used for rendering the report output. |
| WordMergeDataItem | Text[250] | The data item configuration for Word merge operations when using Word layouts. |
| FirstDataItemTableID | Integer | The table ID of the first data item in the report's data model. |
| MaxRows | Integer | The maximum number of rows that can be processed in a single report execution. |
| MaxDocuments | Integer | The maximum number of documents that can be generated in a single report execution. |
| Timeout | Duration | The maximum execution time allowed for the report before it times out. |
| AllowScheduling | Boolean | Indicates whether the report can be scheduled for automated execution. |
| DefaultLayoutName | Text[100] | The name of the default layout used when multiple layouts are available. |
| FormatRegion | Text[80] | The regional format settings used for date, number, and currency formatting in the report. |
| ExcelLayoutMultipleDataSheets | Boolean | Indicates whether Excel layouts support multiple data sheets for complex data presentation. |
| "App ID" | Guid | The application identifier that contains this report. |
| InherentPermissions | Text[5] | The inherent permissions defined for this report (Read, Insert, Modify, Delete). |
| InherentEntitlements | Text[5] | The inherent entitlements required to access this report. |
| "AL Namespace" | Text[500] | The AL namespace of the object. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |