Last updated November 10, 2014. Created on July 13, 2013.
Edited by Pierre.Vriens, metzlerd, msimanga, ctgraham. Log in to edit this page.

Bargraph in SVG format, created with Drupal module Forena (using the SVG Graph library)Forena Reports is built of the idea of using SQL to get data out of a database and use XHTML and CSS to format it into web reports. As an alternative, forena can also be used for reports and charts about data stored in XML files.

It is designed to leverage existing knowledge of HTML, CSS, SQL and JavaScript to help you create rich interactive web reports.

A What You See Is What You Get (WYSIWYG) compatible report editor is provided to make the creation of a basic reports very easy. You don't have to know XHTML and CSS to create a simple report, but the more you now about HTML and CSS, the more you will be able to achieve.

The main differences with other open source reporting solutions are:

  1. Forena leverages HTML and XML in ways that these report engines do not. In Forena everything is XHTML natively, so that is your templating language. This means rather than having users enter parameters, most often they are doing click-through drilling down to their data. Forena produces paper as a secondary thing rather than a primary concern. We are NOT interested in printing most of the time, but rather exploring the data.
  2. Forena lets you consume hierarchical data from non-relational sources such as RSS feeds, etc (anything in XML format) and has special considerations for databases that can generate XML natively (e.g. Postgres or Oracle SQL).
  3. Forena is designed to make generating data sources and reports be report developer friendly. Data queries, often called data blocks, are simple files that can be version controlled and edited using normal development tools. They are often parameterized SQL files, so they don't take much to use. Time from a good select statement to a report is typically 5 minutes or less.
  4. Forena doesn't require a Java stack! So you can install it on a hosting service, etc.

Forena logoNovice users may want to start by creating reports & charts using the built-in WYSIWYG report editor, for which a WYSIWYG Reporting Guide is available to get started.

Users with knowledge of XHTML, CSS and XML may choose to edit the FRX report definition files directly. Checkout this real world example of an FRX file, together with this PDF file containing a preview of the report/chart that was created from it. The FRX Reporting Guide is available for those who are interested in doing so.

Forena is one of the available options to consider for creating charts. Checkout the Comparison of Charting modules for details about Forena's charting features as compared to some of the other modules that are typically used for charting.

Looking for support? Visit the Drupal.org forums, or join #drupal-support in IRC.