Releases for Forena Reports

Fixes :

• #3098559

Contains a minor but important bug fix:

• #2772225: PHP Error when using the FrxInclude renderer

Basic rendering of reports and document types are complete, however the GUI version of the report writer has not yet been ported. Sufficed to say, this version can be used by Drupal 8 report writers who are comfortable writing .frx files and sql elements by hand.

Features and bug fixes included in this release:

Quick bug fix release:

• #2504969: Data block preview redirects to home page

Upgrading from 7.x-3.x?

Please see:
https://www.drupal.org/node/2364807

This version contains the following new features:

• #2350343: Combination Graph
• Default Configuration improvements

The following defects are addressed in this version

Bug fixes including:

Beta 4 Release

This release contains bug fixes and a couple of significant user interface changes most notably:

• Complete help documentation rewrite
• SVG Graphing engine supports pivoting tables (crosstab)
• Performance fixes for sites that use internationalized menus
• Frx Grouping enhancements
• #2347311: Multiple Line Graph, hide null or zero values
• #2324549: Could not give access to non-admin
• #2285287: Call to undefined method DatabaseStatementBase::xpath()
• #2324549: Could not give access to non-admin
• #2278895: Double breaks in reports

Beta 2 Release

Several bug fixes have been added to this release uncovered during testing and deployment.

The Alpha 8 release contains bug fixes only from the previous alpha release.

7.x-4.0 contains significant api changes. Although reports written in 7.x-3.x versions should work the same in 7.x-4.0, changes to the security model have been made.

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.

7.x-4.0 contains significant api changes. Although reports written in 7.x-3.x versions should work the same in 7.x-4.0, changes to the security model have been made.

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.

7.x-4.0 contains significant api changes. Although reports written in 7.x-3.x versions should work the same in 7.x-4.0 changes to the security model.

7.x-4.0 contains significant api changes. Although reports written in 7.x-3.x versions should work the same in 7.x-4.0 changes to the security model.

The following bug fixes/feature requests:

New Feature:

• #2116969: Report Caching

This is primarily a bug fix release including the following:

• Documentation update: Requires you to revert delivered reports to see.
• Fixed bug: Fatal error in xpath expressions {=sum(*/total)}
• Fixed bug: When using the forena filter reports were embedding parameters forms and setting titles.
• Fixed bug: Email merges not correctly passing subjet through to email
• Fixed bug: Float type in typed parameters not working properly
• Fixed bug: Notices thrown in views plugin

The following fixes and features have been incorperated in the new release:

* Security Update: WIth forena enabled, prior to 7.x-3.9 version users could by pass additional node access security hooks to view published content in XML using the forena XML path (forena/xml/blockname. Forena has been modified to allow an extra permission to allow you to not allow access to forena XML blocks without specific privileges. Users would need to have known both paths and content types in order to be able to access this data.

#1839942: Exception thrown by SimpleXMLElement
[#20605777]
Fixed permissions on sample report 5
Fix to save label field.
Fixed regular expressions to not pars :foo:foo parmeters.
Fixed function naming inconsitencies.

Updates since last revision:

• Selects now include prompts. Additional options available for controlling prompt
• Graph labels now go through formatting system
• SVGGraph support for Javascript when directly included. Tooltips now work.
• new frx:invalid_link tag to control how invalid links are displayed.

Bad Commit Do not use

The following fixes have been implemented since the 7.x-3.0 release

Since last Beta

• #1953702: Add support for SVG Graph types CylinderGraph and RadarGraph
• #1951626: 7.x-3.0-beta2 upgrade makes SVG Graph of type scatterplot fail
• #1953468: Error with User Name and anonymous users
• Added support for style tags on document head to contain report specific CSS
• Added support for graph type specific options in .skinfo files
• New DrupalNoad.load php block for loading node data into xml

The 7.x-3.0 release provides several new features most notably PDF document generation. Small feature requests will still be entertained on this branch but focus has now shifted to documentation and training.

The 7.x-3.x version. Significant refactoring was undertaken, however the basic 7.x-2 feature sets are stable and in use on a handful of production sites.

Stable Features

The following new features have been created and are functional in this release:

• Oracle date format: Now uses more standard date/time that is consistent with date api
• Date API Support: parameters may now be defined as date/times with formats.
• Checkbox Support: report parameters may now be defined as checkboxes
• FrxTitle renderer to allow setting of title based on content rendered in the report
• PDF document generation via Prince XML (commercial product) or mpdf (open source)
• New frx:if tag to support conditional logic in Frx files.
• New --IF= comments in data blocks to support conditional inclusion of SQL
• niew --INCLUDE= sytax lets you define queries in terms of another query
• Drush commands for copying reports and clearing forena caches. (frxcc and frxcp)
• Menu support
• Beans integration allowing forena reports as blocks
• Views integration allowing a forena report to be used as a view style