Highlights of version 2501.0.0.0

Features

With the features added in this release of the Aptean Report Data Designer extension,

• You can assign custom aliases to tables included in a report, and these are displayed in the report structure view, alongside the table names.

• You can define parent-child relationships between tables when building report structures. Additionally, the system validates defined relationships to ensure data consistency and logical correctness.

• You can select multiple tables when defining a report structure. This feature provides greater flexibility in report creation by enabling you to combine data from related sources into a single comprehensive report.

• You can create custom formulas for calculated fields within your reports. This feature allows you to perform advanced calculations beyond standard functions, enabling tailored data analysis and in your reports.

• You can define calculated fields using standard aggregation functions. This feature simplifies data analysis by automatically computing totals and averages within reports, allowing you to derive insights without manual calculations.

• You can configure field properties such as captions and formats to make reports more readable and user-friendly. This feature allows you to rename fields with meaningful captions and apply appropriate formats.

• You can select specific fields from tables to include in your reports, ensuring that only relevant data is displayed. This feature allows you to choose multiple fields, customize your report content, and focus on key business insights.

• The system automatically validates selected fields to ensure compatibility with report requirements. This feature helps prevent configuration errors by identifying incompatible data types and confirming valid selections before report generation.

• You can define sorting fields for your report data, allowing you to organize information in a clear and meaningful order. This feature lets you choose one or more fields and specify ascending or descending order to control how data appears in the final report.

• You can define static filters for each data item in your report, ensuring that only relevant data is displayed based on predefined criteria. This feature allows you to set and save filters, which the system applies automatically whenever the report is generated. If an invalid filter is used, the system provides a clear error message to guide you in correcting it.

• You can specify request filter fields at runtime, allowing you to dynamically adjust the data displayed in your report. This feature enables you to select filter fields, define filter criteria, and modify them before generating the report, ensuring that the output is tailored to your immediate needs. If no data matches the selected filters, the system displays a error message to indicate this.

• You can deploy and manage Business Central report projects via a Web API, streamlining app packaging and deployment. The system generates all necessary files including app.json, launch.json, and report files and organizes them into a structured project folder, which can then be zipped and sent through the Web API.

• You can set up report data design through the Report Data Designer Setup page to define parameters required for accessing the Web API and other report data design functionality. For more information, see Set up report data designer.

For more information, see Manage report data designer.