NAME

PDF::ReportWriter::Datasource::DBI

DESCRIPTION

Custom Datasource class that allows access to a generic DBI DSN.

USAGE

Example of code fragment to include in your xml report:

	<report>
	...
	   <data>
	   ...
	   	<datasource name="customer">
			<type>DBI</type>
			<dsn>DBI:Pg:dbname=accounting</dsn>
			<user>postgres</user>
			<pass>postgres</pass>
			<sql>SELECT * FROM customers WHERE id=?</sql>
			<attr>
				<ChopBlanks>1</ChopBlanks>
				<PrintError>1</PrintError>
				<RaiseError>1</RaiseError>
			</attr>
		</datasource>
	   </data>
        ...
	</report>

ISSUES

Currently I don't know why with CSV driver this does not work. Probably it's necessary to tweak the csv_tables or csv_csv structure?

AUTHORS

Cosimo Streppone <cosimo@cpan.org>