Banza report builder for Creatio allows you to configure report export based on any data from the system, and such export can be performed both by users and automatically according to a configured schedule.

Use cases:

• Generating reports and print-ready documents based on section records.
• Make reporting and exporting your data easily.
• Creating templates for your documents with the ability to select the data you want to integrate into the document from your database.

Key features:

• Creating reports based on data from any system object (table or view) in xlsx format.
• Using any Excel file (with formatting, pivot tables, and graphs) as a template for generating a report.
• Adding column headers and applied filters for each report separately.
• Displaying the specified filters in the file name.
• Advanced custom filter settings: custom filter dependency setting, limiting the list of valid custom filter values, setting the mandatory filter and determining the mandatory nature of one filter from a group, defining values for automatic substitution.
• The advanced setting of report columns: the ability to impose a condition for displaying a value in a column, sorting the uploaded values by specified fields, taking into account their priorities, replacing exported values with specified alternative values, and combining values into one column.
• Generate reports according to a set schedule (you can set the day of the week and time or in cron format) and save them to a specified folder for on-site deployment.
• Filtering values for unloading is possible both when pre-configuring the report (primary filter) and when generating it (custom filter).
• Displaying the date of uploading the report in the file name of the specified format.
• Quick report generation from any section of the system.
• Notification to the user about the completion of the report generation process.
• Storing the history of report generation.
• Exporting, importing, and copying report settings.
• Setting access rights to reports.