I want your advice about what tool/lib can I use for reports? Im creating a software based in Python+wxpython and some info need to be sended to the printer and/or PDF like lists, pye or bars diagrams.
I want your advice about what tool/lib can I use for reports? Im creating a software based in Python+wxpython and some info need to be sended to the printer and/or PDF like lists, pye or bars diagrams.
-I’ll use postgresql and sqlite
-Reportlab don’t allow (in the free version) create bars/pye graph and insert in the pdf (right?)
-I’ll use wxpython open rpt use qt I don’t like add qt
I want your advice about what tool/lib can I use for reports? Im creating a software based in Python+wxpython and some info need to be sended to the printer and/or PDF like lists, pye or bars diagrams.
Data coming from a Firebird SQL DB?
I create temporary HTML files and give them to wkhtmltopdf (Work well under MS-Win and Linux).
In the past I tried printing with wxPython, but there is too much problems, so I have stopped.
For bars/pye graphs I use wxPython (I have started with good examples in the demo), make an image and they can be inserted in HTML files.
-I'll use postgresql and sqlite
-Reportlab don't allow (in the free version) create bars/pye graph and insert in the pdf (right?)
-I'll use wxpython open rpt use qt I don't like add qt
What about the print framework in wxpython ?
Mario Lacunza
Enviado desde mi Motorola Atrix2
El nov 28, 2012 2:21 a.m., "Werner" <werner.bruhin@sfr.fr <mailto:werner.bruhin@sfr.fr>> escribi�:
Hi Mario,
On 28/11/2012 01:06, Mario Lacunza wrote:
Hello,
I want your advice about what tool/lib can I use for reports?
Im creating a software based in Python+wxpython and some info
need to be sended to the printer and/or PDF like lists, pye or
bars diagrams.
-I'll use postgresql and sqlite
-Reportlab don't allow (in the free version) create bars/pye graph and insert in the pdf (right?)
Don't know, have you looked at the Dabo stuff, they have a designer and are using Reportlab. I think one could use the report stuff without all of the other Dabo Framework - but then I might be wrong here.
-I'll use wxpython open rpt use qt I don't like add qt
Yes, but it does have both pgsql and sqlite out of the box.
What about the print framework in wxpython ?
I only use it for very basic stuff via ObjectListView, basically just print the shown listctrl.
ReportManager really was/is nice, especially its designer and things like sub-reports etc
Another option is wx.HTML and/or wx.HTMLEAsyPrinting (or something
like that...).
But it only handles basic, non-CSS, non Javascript HTML.
charts and graphs would need to be done with another tool, matplotlic,
for instance.
-Chris
···
On Wed, Nov 28, 2012 at 4:16 AM, Mario Lacunza <mlacunza@gmail.com> wrote:
Mario Lacunza
Enviado desde mi Motorola Atrix2
El nov 28, 2012 2:21 a.m., "Werner" <werner.bruhin@sfr.fr> escribió:
Hi Mario,
On 28/11/2012 01:06, Mario Lacunza wrote:
Hello,
I want your advice about what tool/lib can I use for reports? Im creating
a software based in Python+wxpython and some info need to be sended to the
printer and/or PDF like lists, pye or bars diagrams.
Emergency Response Division
NOAA/NOS/OR&R (206) 526-6959 voice
7600 Sand Point Way NE (206) 526-6329 fax
Seattle, WA 98115 (206) 526-6317 main reception
-Reportlab don't allow (in the free version) create bars/pye graph and
insert in the pdf (right?)
That depends on what you mean. Open source ReportLab is a PDF library
(like fpdf for PHP). It is not a general-purpose report writer. YOU
can certainly create bar charts and pie charts using ReportLab (and it's
not that hard), but there is no "CreateBarChart" API.
You can certainly use gnuplot to create your bar charts as PNGs, and
then embed the PNGs in the ReportLab PDF.
What about the print framework in wxpython ?
The print framework in wxPython is quite primitive, just like the print
frameworks on the operating systems it abstracts.
···
--
Tim Roberts, timr@probo.com
Providenza & Boekelheide, Inc.
Not sure, but maybe I’d make the report objects (charts, plots, tables, whatever) with tools like Matplotlib and then save them as images. I’d then maybe use something like the technique mentioned in this blog post and embed the images in the PDF, using wxPython, Cairo, and Poppler:
On Tue, Nov 27, 2012 at 7:06 PM, Mario Lacunza mlacunza@gmail.com wrote:
Hello,
I want your advice about what tool/lib can I use for reports? Im creating a software based in Python+wxpython and some info need to be sended to the printer and/or PDF like lists, pye or bars diagrams.
To solve my printing problems, I do the following:
Convert my screen to HTML (with style sheets)
Use wxhtmltpdf to convert HTML to PDF (free utility)
wkhtmltoimage may also help you (I never tried this utility)
Use os.startfile to print the PDF file
Bruce
···
On Tuesday, November 27, 2012 7:06:24 PM UTC-5, Mario Lacunza wrote:
Hello,
I want your advice about what tool/lib can I use for reports? Im
creating a software based in Python+wxpython and some info need to be
sended to the printer and/or PDF like lists, pye or bars diagrams.
http://relatorio.openhex.org/
Used by Tryton but I cant see updates since 3/2012, poor docs because I need to learn Genshi template system to work with.
Looks good including a graphic tool for create reports, oriented to obtain info from DB. Zero docs.
Printing Framework
I just finish the read of Chapter 17 from Robin book, I think it have a great potential, its remember me the objprinter in VB6 Using it can I expect troubles from printers? or the print out is very standard?
By now Im really interested in Geraldo reports, in the future my system will be deployed in web too (using Django I think) so using the same report component in both environments is a plus...waiting comments
On Tue, Nov 27, 2012 at 7:06 PM, Mario Lacunza <mlacunza@gmail.com > <mailto:mlacunza@gmail.com>> wrote:
Hello,
I want your advice about what tool/lib can I use for reports? Im
creating a software based in Python+wxpython and some info need to
be sended to the printer and/or PDF like lists, pye or bars diagrams.
Not sure, but maybe I'd make the report objects (charts, plots, tables, whatever) with tools like Matplotlib and then save them as images. I'd then maybe use something like the technique mentioned in this blog post and embed the images in the PDF, using wxPython, Cairo, and Poppler:
Geraldo reports, in the future my system will be deployed in web
too (using Django I think) so using the same report component in
both environments is a plus…waiting comments
thanks for the answer...I think my best choice for reports could be: reportlab + matplotlib + GeraldoReports
Like my future system will be installed in Windows/Mac/Linux all these packages have an exe/dmg easy to install file... and offer me all I want for graphs and reports...
-Reportlab don't allow (in the free version) create bars/pye graph and
insert in the pdf (right?)
That depends on what you mean. Open source ReportLab is a PDF library
(like fpdf for PHP). It is not a general-purpose report writer. YOU
can certainly create bar charts and pie charts using ReportLab (and it's
not that hard), but there is no "CreateBarChart" API.
You can certainly use gnuplot to create your bar charts as PNGs, and
then embed the PNGs in the ReportLab PDF.
What about the print framework in wxpython ?
The print framework in wxPython is quite primitive, just like the print
frameworks on the operating systems it abstracts.
You can create very nice bar and pie charts with the free version of Reportlab either as stand-alone .png files or insert them into pdf. Maybe it is the use of Reportlab through the Dabo report generator that doesn’t support graphs?
thanks for the answer, I think I read too fast the reportlab guide... I'll check it again, because if I can create graphics (bars & pie) with no external libraries with the free version its enough for my project... I'll make some test and comeback with results..
Maybe another dev with previous experience with reportlab can confirm this?
On Wednesday, 28 November 2012 12:16:00 UTC, Mario Lacunza wrote:
-Reportlab don't allow (in the free version) create bars/pye graph
and insert in the pdf (right?)
You can create very nice bar and pie charts with the free version of Reportlab either as stand-alone .png files or insert them into pdf. Maybe it is the use of Reportlab through the Dabo report generator that doesn't support graphs?
On Wednesday, 28 November 2012 12:16:00 UTC, Mario Lacunza wrote:
-Reportlab don't allow (in the free version) create bars/pye graph
and insert in the pdf (right?)
You can create very nice bar and pie charts with the free version of Reportlab either as stand-alone .png files or insert them into pdf. Maybe it is the use of Reportlab through the Dabo report generator that doesn't support graphs?
I never succeeded to understand why you are working
in that way.
You can produce a plain text .tex file and let it compile
with one of the TeX engines.
I can not figure out something more simple (and powerful).
···
Le mercredi 28 novembre 2012 14:19:07 UTC+1, Hugues JEAN-BAPTISTE a écrit :
Hi Mario,
I create temporary HTML files and give them to wkhtmltopdf (Work
well under MS-Win and Linux).
In the past I tried printing with wxPython, but there is too much
problems, so I have stopped.
For bars/pye graphs I use wxPython (I have started with good
examples in the demo), make an image and they can be inserted in
HTML files.
Well that could be for many reasons and in some scenarios could be helpful create html (for example for web systems)
Anyways your solution in this case looks more complicated for me, I need an extra lib to create Latex files (or I'm wrong?) and the point is I need create reports, so txt is a bad solution, another step not necessary for me (in my case again)
I need take the info from the database and send to the report engine, it need to create the report in the most easy way for me and for the client, my software will be distributed between people newbie in Linux and with Python in general, so I dont like create a software with:
requirements:
lib a
lib b (this need lib c and x)
lib d
lib e (this need lib y)
a client of me read it and he will choose another software... off course I can create a self installed package (exe, bin, etc) but that increase dev time and deploy time.
Le mercredi 28 novembre 2012 14:19:07 UTC+1, Hugues JEAN-BAPTISTE a écrit :
Hi Mario,
I create temporary HTML files and give them to wkhtmltopdf (Work
well under MS-Win and Linux).
In the past I tried printing with wxPython, but there is too much
problems, so I have stopped.
For bars/pye graphs I use wxPython (I have started with good
examples in the demo), make an image and they can be inserted in
HTML files.
---
I never succeeded to understand why you are working
in that way.
You can produce a plain text .tex file and let it compile
with one of the TeX engines.
I can not figure out something more simple (and powerful).
But no response now for nearly a week to posts to their
google-groups-
no moderator who approves them, so they don’t even show for other
users to help out.
Like it and it is to get going, but not sure if/how it deals with
more complex reports.
Didn’t really look at it much as no docs is a show stopper in my
view. Had finally a look at it after Mike D. had mentioned it to
me.
There are docs which are here the “Templates” is for 0.6.x and the “Printouts” is an old one and
there is the API one for the base and the designer (unfortunately
using Epidocs and not Sphinx).
In my view more difficult to get going and it had a few issues when
trying to use it with wxPython 2.9.4. However Alex and Den worked
with me to get them ironed out and Alex just made an 0.6.1 release
with these corrections and he also added “Preview” and “Print” to
the wxPython based designer.
The designer is in my view a huge advantage as down the road I like
users to at least be able to tweak report layout without needing
Python experience.
So, enough off topic stuff
Werner
Well this is not an offtopic I guess, at least with my next response:
After some tests I want to use:
wxpython (pieCtrl and pyplot)
reportlab
numpy
for all my reports and on screen graphics, with it I can obtain a minimum extra libs required and keep all my code clean. Another requirement was keep the by default libraries preinstalled with Ubuntu 12.04 LTS to be used for the entire system.
But no response now for nearly a week to posts to their google-groups:-( - no moderator who approves them, so they don't even show for other users to help out.
Like it and it is to get going, but not sure if/how it deals with more complex reports.
Didn't really look at it much as no docs is a show stopper in my view. Had finally a look at it after Mike D. had mentioned it to me.
There are docs which are here http://pythonreports.sourceforge.net the "Templates" is for 0.6.x and the "Printouts" is an old one and there is the API one for the base and the designer (unfortunately using Epidocs and not Sphinx:-( ).
In my view more difficult to get going and it had a few issues when trying to use it with wxPython 2.9.4. However Alex and Den worked with me to get them ironed out and Alex just made an 0.6.1 release with these corrections and he also added "Preview" and "Print" to the wxPython based designer.
The designer is in my view a huge advantage as down the road I like users to at least be able to tweak report layout without needing Python experience.
