DBIx::SQLCrosstab 1.14 was submitted to CPAN today.
Purpose: Create server-side multi-level cross tabulations in SQL
Main features:
- single and multiple level headers in rows and columns
- query creation upon minimal parameters requirement
- support for multiple operations in the same query (e.g count
and sum, or sum and avg, max, min, std)
- column totals and sub-totals (all in SQL)
- row totals and sub-totals (all in SQL)
- removal of empty columns
- exclusion of values from column headers
- manual or automatic definition of column headers
The companion module DBIx::SQLCrosstab::Format can also return nicely
formatted reports in several formats:
- HTML (with properly calculated row and column spans)
- HTML (simple)
- XML
- CSV
- YAML (requires additional module YAML)
- Excel spreadsheet (requires additional module
Spreadsheet::WriteExcel)
- Perl structure (lol, loh, hoh)
Test environment:
databases: MySQL and SQLite;
OS: Linux (Mandrake, Debian), Windows XP
Perl: 5.6.1, 5.8.0 and 5.8.1
DBI: 1.37, 1.38
See a live example at http://gmax.oltrelinux.com/cgi-bin/xtab.cgi
Comments welcome
gmax
