Generate reports from enhanced XML snapshots

The enhanced XML snapshot data includes the following metadata for each field:

Field	Description
Field ID	Unique identifier of the field
Field Name	Name of the field
Field Value	Value of the field at snapshot time
Table ID	Unique identifier of the table
Table Name	Name of the table

This functionality provides the following benefits:

• Dynamic report dataset generation: Report data designer can dynamically generate datasets from XML snapshots without hardcoding field structures, allowing reports to adapt to data model changes.
• Complete audit trail: Missing or changed data elements are logged separately, providing a complete history of structural changes for regulatory compliance.
• Flexible reporting: Reports can reference historical data accurately even when the current data structure has been modified.

To use enhanced XML snapshots in report data designer, follow these steps:

1. Select the Search icon , enter Report Data Designer List, and then choose the related link.
   The Report Data Designer List page opens.
2. On the action bar, select New to create a report data design.
   The Report Data Design Card page opens.
3. On the General FastTab, enter the report code, description, and report name.
4. In the Data Source field, select required option.
   • Database: Data is generated from database tables.
   • XML: Data is generated from XML snapshots.
5. The system dynamically generates the report dataset structure from the XML snapshot metadata.
   Field IDs, field names, table IDs, and table names are automatically populated from the snapshot XML, eliminating the need to manually define field structures.
6. On the action bar, select Generate Report Code to create the AL code for the report.
   The report uses the enhanced XML metadata to build the dataset, ensuring accurate historical data representation.
7. On the action bar, select Build and Deploy App Package to deploy the report.
   The report is available for use with XML snapshot data.