Making Custom Reports

There are three kind of reports in EnigmaERP.

1. Report Builder#

Report Builder is an in-built report customization tool in EnigmaERP. This allows you to define specific fields of the form which shall be added in the report. Also you can set required filters, sorting and give preferred name to report.

2. Query Report#

Query Report is written in SQL which pulls values from account's database and displays the same in the report. Though SQL queries can be written from front end, like HTML, it has been restricted for EnigmaERP cloud users. This is because it allows users with no access to specific report to fetch data directly from the database.

3. Script Report#

Script Reports are written in Python and stored on server side. These are complex reports which involves logic and calculation. Since these reports are written on server side, customizing it from hosted account is not possible.

> Note: Dynamic Filter is available in Script Reports and Query Reports; however, not in the Report Builder.

Adapted for EnigmaERP from the ERPNext documentation, © Frappe Technologies Pvt. Ltd. Content licensed under CC-BY-SA 3.0. EnigmaERP is a product of Enigma and is not affiliated with or endorsed by Frappe Technologies Pvt. Ltd.