Add Office reporting feature to your APEX application

Why use APEX.report?

APEX.report allows you to easily generate Excel files based on XLSX template files and data returned by SQL query.

This unique solution on the market gives you the possibility to edit template files using an Excel application (e.g. to apply formatting and computations) and provide a query that fills this template during runtime XLSX generation. Query can have bind variables (parameters) that allow you to reference APEX session variables.

 

Main functions/ features:

• • you can easily export data to .xlsx file
  • SQL query or function returning SQL as a data source
  • data export based on dynamic SQL
  • dynamically created set of result columns
  • you can pass parameters to SQL query
  • you can present data using the chart in your template
  • you can easily and flexibly create and use of templates using Microsoft Office Excel
  • support two results set in the same xlsx
  • you can hide any sheets in template (for example hide sheets with source data or not applicable sheets in report)
  • further customization using page item substitution

 

Usage examples:

 

Sample application using APEX.report:

Report and dynamic chart:

Charts can be dynamically adjusted and resized by plugin to match number of columns.

Data from: https://www.kaggle.com/jingbinxu/sample-of-car-data

 

Licencing and pricing:

• 1500 euro – one time licence fee for two APEX instances (includes email support and free software updates for 1 year).
• Optional: 20% maintenance and support fee per year starting from second year (includes email support and free software updates).