-
Notifications
You must be signed in to change notification settings - Fork 116
Significant Changes
Support for Excel 2007 file formats (xlsx) requires updating "pentaho-reports" from within Odoo. It also requires that you are running a new deployment of the war file.
If you are happy to use Pentaho 5.2 as the reporting engine, then you can grab and deploy the pre-built war file from the Willow website.
If, however, you wish to continue using Pentaho 5.0 or Pentaho 3.9 reporting engines (theoretically not necessary, not even for OpenERP 6.1) then you will need to grab the latest from the java_server part of the project, and re-build your own war file.
Rebuilt war file put on on Willow website to support Pentaho version 5.2. No Changes to Odoo (OpenERP) addon.
Upgrade and test for version 8.0.
A selection set can be nominated as the default to display for selected users, or for selected security groups.
User defaults take precedent of group defaults. If more than one default is set for the user, then one will be chosen randomly.
Default values for selection sets have been extended to allow for use of expressions and a limited number of functions. This includes support of default values for multi-selection lists. Additionally, other parameters can be referenced.
Example defaults, and selection functions currently available can be found on the wiki page Parameter Set Selection Functions
The report scheduler can run a report using a previously saved selection set.
Willow IT's report email and message scheduler has been tailored and integrated.
This module introduces the ability for reports to be run by the OpenERP scheduler. The resulting reports can be emailed, messaged, or both to selected users.
Users with adequate security can now save report selections as a selection set. All users can access those selection sets through a pull down.
When the user chooses to save report selections, the current selections on the screen are assumed to be the ones needing to be stored. However, each parameter can be overridden from the presented wizard before saving the selection set.
Multi value selection lists are now supported. These work on the report wizard screen as an OpenERP many2many widget. The values are passed to the report as a list.
Tested with Pentaho version 5.0.
This allows for a handful of new reporting widgets and some other reporting improvements. Most significantly, the OpenERP data sources are now bundled in to the report designer and do not need special installation.
Pentaho prompted parameters have optionally worked with pull down lists of values provided by other queries. Until now, those queries have not supported passed special variables. This support has now been added so that parameter queries can now use:
- ids: the context ids when the report action is called.
- user_id: the id of the user running the report.
- user_name: the display name of the user running the report.
- context_lang: the language in effect when the report action is executed.
- context_tz: the timezone in effect when the report action is executed.
This allows for better restriction of selectable values depending on the user and context when the report prompting wizard is created.
Pentaho Report Actions now better integrated with standard OpenERP Report Actions.
Significantly, this enables easier switching of existing report actions (such as invoices or picking slips) to be Pentaho based reports.
The menu item "Pentaho Reports" has been removed from the OpenERP menus. To view and maintain Pentaho Report Actions now, the Settings/Technical/Low Level Objects/Actions/Reports needs to be used. Note that there is a filter which quickly allows display of Pentaho Report Actions.
Refactored code and tested for compatibility with OpenERP version 7.0.