DBIx::SQLCrosstab version 1.10
==============================

Creates a server-side cross tabulation from a database

DESCRIPTION

DBIx::SQLCrosstab produces a SQL query to interrogate a database 
and generate a cross-tabulation report. 
The amount of parameters needed to achieve the result is kept to 
a minimum. You need to indicate which columns and rows to cross 
and from which table(s) they should be taken.
Acting on your info, DBIx::SQLCrosstab creates an appropriate 
query to get the desired result.
Compared to spreadsheet based cross-tabulations, DBIx::SQLCrosstab 
has two distinct advantages, i.e. it keeps the query in the 
database work space, fully exploiting the engine capabilities, and 
does not limit the data extraction to one table.

The companion module DBIx::SQLCrosstab::Format provides nicely 
formatted output in HTML, XML, YAML, CSV, xls, and of course as
several Perl structures (lol, loh, hoh). 

VERSION

This is the initial distribution. The module has been tested 
extensively in private, but of course the public scrutiny is 
different, so I expect to get some bug reports in a near future.
You may consider this code as Beta.


INSTALLATION

To install DBIx::SQLCrosstab type the following:

   perl Makefile.PL
   make
   make test
   make install

EXAMPLES
In the directory examples there are several files:
    - crosstab.sqlite   is a database in SQLite format
    - sqlcrosstab_example.pl is an example of how to set
             the initial parameters and get the results
             in several formats.
    - create_crosstab_innodb.mysql and create_crosstab_myisam.mysql 
         contain the sample database in MySQL format
    - crosstab_sample.html contains the database structure and
         description

DEPENDENCIES

This module requires these other modules and libraries:

  DBI
  one DBD driver module
  Tree::DAG_Node

Optionally, if you want to produce YAML output, the YAML module 
should be installed.
Similarly, for Excel spreadsheet output, you should install
Spreadsheet::WriteExcel


COPYRIGHT AND LICENCE

Copyright (C) 2003 Giuseppe Maxia

This library is free software; you can redistribute it and/or modify
it under the same terms as Perl itself.