Forena is database report writing software built on the Drupal platform. Forena is built of the idea that if you can write the SQL necessary to get the data out of a database, it should take very little work to get that data out on the web. It is designed to leverage knowledge of HTML, CSS, SQL and Java Script to help you create rich interactive web reports.

Note: Before trying out forena make sure you have private file systems properly configured. It doesn't need to be set as the default delivery method, but it does need to be configured.

Drupal 8 Version

Work on the Drupal 8 Version is in progress! I will release an early alpha once the base reporting engine is functional with unit test coverage before beginning work on the WYSIWYG reporting interface. The future of the Drupal 8 Version is a bit uncertain. Please help me understand where this product needs to go by filling out the survey at Forena.org or by leaving a comment on this issue.

Features

The current version allows you to create reports using SQL from Drupal, or using data stored in XML files.

It comes bundled with a couple of sample reports that will both demonstrate how reports are created, and provide useful information on your existing Drupal site.

Some key features include:

Create custom reports from your Drupal database.
Create custom reports against PDO supported database (SQLite, MySQL, MS SQL, etc).
Create custom reports against any Oracle database.
Create charts in SVG format.
Export data to CSV, EXCEL or XML versions of reports.
Create and edit HTML reports using a simple web UI (includes WYSIWYG editor support).

Integration with Other modules

Integration with external libraries

JQuery Datatables to support table pagination sorting and rows.
MPDF is used to dynamically create PDF documents.
PrinceXMLcommercial PDF generation Software
DocRaptor PDF generation service
SVGGraph is used to create SVG charts and graphs.
Virtually any JavaScript library may be used with Forena to produce amazing displays.

Related projects

For a more accurate summary of projects related to forena, checkout related projects in the community documentation.

Documentation

Documentation about forena is available in various flavors:

Where does it get its name?

The project name is derived from the Swedish word that means to connect. That's just what we hope to do with this application is to connect people with their data.

Helping Out

Forena Development has moved to GitLab
See ourGitlab Project Site for more information.

We're always looking for more maintainers with a need for a good enterprise reporting application that really embraces the power of the web, XML, and relational data. Alternatively, you can install forena and build your own reports and charts and contribute them back.

Please stay tuned for future developments.

Forena Reports

Issues

PHP 7.4 and PHP 8.1 compatibilityNeeds reviewCode Created over 2 years ago

Add code bar to ReportsFixedReport Created almost 8 years ago

PHP 7.4 and PHP 8.1 compatibility
Needs review
Code
Created over 2 years ago

Add code bar to Reports
Fixed
Report
Created almost 8 years ago