webform_report 6.x-2.0

This is the official 6.x-2.0 stable release of Webform Reports.

This version features some major revisions to the Webform Report 6.x-1.x version. If updating from version 1.x, a database update is required before it will function - please run update.php on your site after updating the module. You will probably also need to clear the site cache before the module will function correctly.

Updates / Features added:

• The report form now works in a more generally accepted manner and includes the following changes:
• The form will not longer submit itself as you go along.
• When adding a new module, the only fields available are the title, description, and the webform - the webform must be selected at this time.
• After a report is added, the webform can no longer be changed.
• The Report Criteria form now contains lists of report columns, filters, sorts, and options.
• The report columns, filters, and sorts behave similar to Views in that they are composed of lists that can be ordered.
• Report components (columns) can be placed in any order on the report.
• Format options are now available for Date and Time fields.
• Multiple report filters can be specified. Greater than, Less than, and Between options have been added.
• Reports can be initially sorted by multiple columns.
• Report building has several optimizations:
• Only included components (columns) are initially selected from report submissions.
• Report filters are applied at initial selection time, so only filtered data is carried forward to formatting and sorting.
• An end-user search form is now available as an option on the report display.
• A PHP Code option has been added to enable additional processing not otherwise possible in the criteria form. Use with caution, however, as incorrect or malicious code can crash or damage a site.

The following bug/features were addressed during the development of this release:

#299414: Add search field to reports
#327203: Ability to determine column display order
#487414: Pagination Problem
#813160: Option to disable export
#832690: Unknown column 'columns' in 'field list' query error
#833912: "File" type field column is empty
#847610: Delete option on the report
#865754: patch to "select" type column to show value instead of key
#867908: Date Range Report Filter
#930514: Concatenation, Advanced filtering, Selecting morer than one Webforms to generate a report, & Webform Report Tutorial
#945396: CSV Export with special characters(german/french umlauts) and different delimiter
#945398: csv file: wrong results for multiple listbox select
#952128: Multiple column sort does not work
#969908: Date Range Report Filter Continued...
#988398: Results per page
#1040156: "Contains" No Longer a Filter Option for Dates
#1057742: WebForm Report not Setting Upon Creation

Big thanks to everyone who tested, reported bugs, suggested features, and submitted patches to help make this release possible.

Please post any problems, comments or suggestions on the Issues page of this project.