forena 7.x-4.0

7.x-4.0 contains significant api changes. Although reports written in 7.x-3.x versions should generally work the same in 7.x-4.0, changes to the security model have been made. After upgrading please see the documentation regarding changes in the reporting api.

The report editing user interface has been completely redesigned

Note that the fields tab has been replaced by clicking on the gear icons next to the first occurrence of each field. Also note that you can now use the template editors to make changes to each block. You can add and remove data sections to your report as well. Feedback would be appreciated via the issue queue. Also, The edit and translate tabs have been changed to iconic links that will keep report parameter context to simplify the editing process.

New Features

• Forena query builder now supports SQL auto-completion
• Report editing user interface has been completely redesigend
• Module provided reports are no longer copied to the files directory.
• Caching may now be enabled on a per report bases.
• Accessing data from a data source now requires an "access mysource data" privilege
• ACCESS= comments are now optional in data blocks
• Various UI improvements to the report editing experience
• The forena cache now uses standard drupal caching, no more clearing of the forena cache.
• New FrxCrosstab renderer for making cross tab displays of data
• Support for crosstab generation prior to graphing
• Complete help documentation rewrite
• Frx Grouping enhancements

Upgrade Instructions

After installing this release you will want to "Revert all Delivered Reports" to original using the same method that you used to copy Forena's reports to begin with. Either visit Structure->Forena Reports , check the box to "Revert Delivered Reports to original" and press the Revert button. Or using drush , execute the drush frxrevert (was called frxcp). This will remove any forena delivered reports from your sites/.../files/reports folder.

Also, please visit revisit your forena permissions as a new permission has been created for each defined database connection.

Finally make sure that if you are using the php SVGGraph library that you have upgraded to at least version 2.11.