[reportlab-users] Using report lab for generating database re ports.

Henning von Bargen reportlab-users@reportlab.com
Wed, 11 Sep 2002 09:00:36 +0200


> From: =3D?iso-8859-1?q?Bj=3DF6rn=3D20Platzen?=3D <info@sosnetz.de>
> Subject: Re: [reportlab-users] Using report lab for generating =
database
reports.
>=20
> Hello Henning,
>=20
> I am coding a package with PHP and Python wich does something like=20
> you wanted. The whole Database-Input/Output - Thing is coded in PHP,
> the generation of the PDF is coded in Python with the RLTK.
>=20
> The most of the package is OpenSource. But we are still not ready =
with
> this. So at the moment it needs some advice to use it
> (not just download and go...).
>=20
> If you are interested in this, just drop me a line and we will see, =
if the

> package fits your needs.
>=20
> Regards,
>=20
> Bjoern
>=20
> info@sosnetz.de  -  http://www.sosnetz.de

Hello Bj=F6rn,
Yes, I am interested.=20
But why do you use PHP and not Python?

> From: John Leach <reportlab@osware.net>
> Subject: Re: [reportlab-users] Using report lab for generating =
database
reports.
>=20
> I have a Forms Designer which is a Python tkinter GUI.
> This then generates a python script with calls to python methods to =
call
the=20
> reportlab methods to output the fields.
> The script can be edited manually.
> It's not quite what you have in mind but my experience in producing
business=20
> documents such as Invoices, Purchase Orders etc is that it is =
possible to=20
> edit the script so it gives good results in all cases without manual=20
> intervention. This is done by having two passes through the data - =
one to=20
> work out the pagination - and the second pass to output the =
information.
> This approach may work for you.
> John Leach

This sounds _very_ interesting. Can you describe it more detailed
or even donate the code to the community?

> >
> > A much more complex approach
> > (but I think _possible_ with ReportLab, compare the platypus debug =
mode)
> > would be to allow the user to change the story file by
> > clicking with the mouse in the generated PDF file.
> > Then the cursor would be positioned at the corresponding position =
in the
> > story file.
> >

I want to further explain it here:
The idea is to attach information about where (story filename, line#)
a Flowable object comes from to each flowable.
Then one could possibly write a function that opens the file and sets =
the
cursor position when clicking on an object in Acrobat Reader.
Is that possible?

Henning

> Thanks for the interesting info on Oracle Reports.  Just fyi, we have
> a non-free product called rml2pdf which would make this extremely =
easy
> -- rml2pdf, which has a built in template/generator facility.  You =
might
> want to have a look, especially if you need to have "non-programmers"
> designing  the reports.  The license price is currently discounted =
$3k.
>=20
> Hope you find it of interest!  -- Aaron Watters

I'll take a look at it.

> From: Jerome Alet <alet@librelogiciel.com>
> Subject: Re: [reportlab-users] Using report lab for generating =
database
reports.
>=20
> On Tue, Sep 10, 2002 at 02:33:15PM +0200, Henning von Bargen wrote:
> >     This story could be RML markup=20
> >     (sorry, but I think that RML is still too expensive)
>=20
> I've never bought RML, but if you use Oracle you can certainely
> afford paying for RML ;-)
>=20

The database itself isnt' too expensive.
10000$ per CPU license for RML in ADDITION to the thousands$ Oracle =
licences
makes a _significant_ difference for our customers.
Now, with 3000$ it is at least worth thinking about it...

Henning