ANNOUNCE: DBIx::SQLCrosstab

[Giuseppe Maxia]

DBIx::SQLCrosstab 1.14 was submitted to CPAN.
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 (Notice though that DBIx::SQLCrosstab
           is database agnostic. It uses standard ANSI SQL and should
           work with any ANSI compliant DBMS);
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