[reportlab-users] Use With SQLite3

[Rich Shepard]

On Tue, 13 Feb 2007, Paul McNett wrote:


> Rich, FWIW Dabo is fairly modular, and in particular the report writer

> doesn't need to feed from a Dabo cursor. You can just feed it a tuple of

> dicts, where each element in the tuple is a record, and each item in the

> dict is a field, the key being the field name and the value being the

> field value.


Paul,

   How kewel!! When I 'select from ...' with pysqlite2 I get a list of
tuples. Your tuple of dicts is interesting, and I think it's elegant.


> You can use wxPython, sqlite, and Dabo's report writer together with no

> trouble. You can hand-code your report definition files by hand, or you

> can use the Dabo Report Designer to visually design them. It is just

> easy-to-follow XML.


   OK. You've sold me on it. :-)


> We found it a pleasure to wrap Reportlab for the Dabo Report Writer, as

> it is a powerful, easy to use API. If you want the typical "Crystal

> Reports" banded-type report with grouping, the detail band, etc., you

> probably would benefit from the work we've put into the Dabo report

> writer. Otherwise, you can use reportlab directly to achieve the same

> ends or more general goals.


   In one application the output is primarily the model input data and a log
of the execution with the output. In another application we're doing (using
postgres as the backend rather than sqlite for several solid reasons), there
will be a combination of textual, filled forms, and numeric reports. The
latter include monitoring data and summary statistics.

   I never used Crystal Reports back when I worked in the DOS world. I left
dBASE-II (under CP/M) for Paradox and used it's report writer. Same thing,
though.

   You'll see me on the web site soon. :-)

Very much appreciated,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863