Reporting for Mendix

Category: Modules
Subcategory: Import/Export

Overview

Are you looking for a fast way to create reports? With the Reporting 4 Mendix module you can create reports for Mendix application very easily. Faster and broader than the standard Mendix reports. When to use? - If standard Mendix reporting is too slow and BI software just a step to far - For developing fast dashboards - For environments with extensive data - For filling in ad hoc reports requests What does the module Reporting 4 Mendix contain: - Graphical OQL builder (run-time) - Support of complex OQL queries - Scheduled collection of statistics for reporting - Maps of query data to persistent data (for statistics collection) - Delete schedule: clean queries for historical data to clean at night For who: - For application managers to make ad-hoc queries - For business engineers to develop dashboards based on query data - For end users to look in on the reports and dashboards Benefits: - Flexible: Does not need a new release for every new report - Fast: Direct OQL on the database and export without data persisting - Support for: n-deep joins, selects, aggregates, having, where clauses, order by and more - Import and export queries around an environment with the DTAP sync extension - Use calculated attributes in OQL queries More technical information - Support for: n-deep joins, selects, aggregates, having, where clauses, order by and more - Import and export queries over and around environments with DTAP sync extensions - Use calculated attributes in OQL queries

Documentation

Demo urlhttps://www.appronto.nl

Description

Create csv and Excel documents data from your app, generate data for your pie charts or raw datasets for reporting or statistics. This can all be done visually by a graphical OQL/Query designer.

Features and limitations

  • Create OQL queries runtime (including, joins, selects, grouping, aggregates, havings, where clauses, order by, ..), at runtime and visually.
  • Get your data from every entity in your app
  • Extend your joins in the queries (N-deep)
  • Custom selects or queries possible
  • Export/Import queries between your acceptance and production environments (you need the DTAP sync module for this)
  • Use calculated attributes in your OQL queries
  • Generate complex queries and use the output for further processing in your app (for example: data for graphs or statistics)
  • Write query results back into your database with advanced mappings functionalities so that it can be used for charting purposes or statistics gathering.
  • Delete data from your database (clean up) with OQL queries.
  • Directly dump OQL to CSV.

Dependencies

  • Mendix Modeler 5.9.1 or higher
  • MxModelReflection 
  • Simple CSV Exporter 
  • Appronto Licenser 
  • Community Commons
  • ReportingForMendixDTAPSync module (optional)

Installation

  • Download module and dependencies
  • Fix layout by batch replacing layouts; Modeler menu -> Tools -> Batch update layouts (see screenshot)
  • Add the To use / AfterStartUp_ActivateProduct_Reporting to your general after start up microflow
  • Add at least the following to your navigation from the to use folder
    • Query_overview
    • OpenOQLToCSV
  • If you want some of the more advanced functions also add the
    • QueryMapping_overview
    • DeleteSchedules
  • Now it's time to start-up your model. After start-up make sure to sync your MendixModelReflection to get the best out of this module.
  • To create your first query / report please see the blog post on appronto.nl
  • For examples on how to create a Report, see the blogpost on this topic on  https://www.appronto.nl/over-appronto/blog/how-to-use-the-reporting-4-mendix-module
 
 

Limitations and licensing

Note: to run the module in the cloud and/or production you’ll need a license. In development on your local machine the module will run without license. You can obtain a free license for cloud Test and Acceptance environments. For production license please contact info@appronto.nl.

The subscription fee starts at € 1035,- euro / year. The fees are yearly and paid upfront, just like Mendix. For the fee we make sure the module stays up-to-date with the latest Mendix releases, we provide support and release new functionalities.

 

Known bugs

  • None reported, please report bugs at products@appronto.nl 

Releases

Version: 2.5.2
Framework Version: 8.12.0
Release Notes: Mendix 8.12 Upgrade (See version 2.5.1 for Mendix 7.2+) This is a minor upgrade in which we added a Decimal rounding feature. For Decimal data types in the Select fields, it is now possible to indicate formatting option by specifying the number of digits for the fractional part of the value. Rounding option will apply when the number of digits is less than the actual value. For example 10.4567 becomes 10.46 when 2 rounding digits are required. The other way around, 0’s will be added to return the total number of given digits. For example 10.4567 becomes 10.45670000 when 8 rounding digits are required. (Not that importing the file in Excel will strip off the trailing 0’s.) The Rounding option can be set per Select field. Dependent modules: With this upgrade, it is also necessary to upgrade the SimpleCSVExport module. Important! For existing customers, many customizations may have been implemented outside of the regular Marketplace releases. You might be using a customized version already which is different from the one in the Marketplace. This upgrade follows the version in the Marketplace and might cause your custom functionality to break. Roadmap A total redesign of this module is scheduled for the upcoming months. We’ll be implementing tons of new features and improvements to make this module the best tool to handle your data!
Version: 2.5.1
Framework Version: 7.2.0
Release Notes: This is a minor upgrade in which we added a Decimal rounding feature. For Decimal data types in the Select fields, it is now possible to indicate formatting option by specifying the number of digits for the fractional part of the value. Rounding option will apply when the number of digits is less than the actual value. For example 10.4567 becomes 10.46 when 2 rounding digits are required. The other way around, 0’s will be added to return the total number of given digits. For example 10.4567 becomes 10.45670000 when 8 rounding digits are required. (Not that importing the file in Excel will strip off the trailing 0’s.) The Rounding option can be set per Select field. Dependent modules: With this upgrade, it is also necessary to upgrade the SimpleCSVExport module. Important! For existing customers, many customizations may have been implemented outside of the regular Marketplace releases. You might be using a customized version already which is different from the one in the Marketplace. This upgrade follows the version in the Marketplace and might cause your custom functionality to break. Roadmap A total redesign of this module is scheduled for the upcoming months. We’ll be implementing tons of new features and improvements to make this module the best tool to handle your data!
Version: 2.5.0
Framework Version: 7.2.0
Release Notes: Mendix 7.2.0 release