Introduction
Welcome to the Empress Report Builder guide. This guide will help you understand and leverage the functionality of the Report Builder - a core feature that enables users to create, edit, and delete reports without writing any code. This feature is a fundamental part of Empress, making it a powerful tool for developers who need to generate data reports from single DocType and Child Tables records.
What is Report Builder?
The Report Builder is an intuitive feature that simplifies the process of creating reports. By default, it generates a Report View for all DocTypes. Developers can save multiple reports based on different combinations of filters, orders, columns, and other parameters. Also, this feature allows the grouping of columns and the application of aggregate functions such as Count, Sum, and Average.
Saving Reports with Report Builder
To save a report, you can utilize the Report Builder’s default functionality. This action stores a Report View for every DocType in the system, providing an overview of all records.
Here’s a snapshot of how the Report Builder works:
Report Builder
Updating or Deleting Custom Reports
The Report Builder allows users to modify or remove any custom report they’ve created. This process is accomplished directly from the Report View. It helps developers maintain accurate and relevant reports by enabling them to make necessary adjustments or deletions.
Here is an illustrated example of how you can update or delete a custom report:
Update or Delete a Custom Report
Printing Reports
The Report Builder also offers a printing option. Users can print reports directly from the Menu, which enables quick and easy access to hard copies of data.
Below is a demonstration of the printing feature in action:
Report Builder Print
Grouping Columns
The Report Builder feature promotes data analysis by allowing users to group columns and apply aggregate functions. These functions include Count, Sum, and Average, which can provide valuable insights into data trends and patterns.
The following illustration shows how to apply the group by clause on columns:
Report Builder Group By
Keyboard Navigation and Editing
Moreover, the Report Builder supports keyboard navigation and editing. As a view of a single DocType, reports can be edited directly, providing an efficient way to make changes.
Here’s a quick look at how keyboard navigation and editing work in the Report Builder:
Report Builder Editing
In conclusion, the Report Builder is a robust feature that enhances the developer experience in Empress. It simplifies report generation, modification, and deletion, thereby accelerating development and customization processes. By mastering this feature, developers can optimize their work in Empress, saving time and effort while delivering sophisticated business solutions.