Database Report Generators

Has anyone created a wxPython app over a database back end and used either
papyrus or ReportLab/Preppy to format reports from the table data?

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

Rich Shepard wrote:

  Has anyone created a wxPython app over a database back end and used either
papyrus or ReportLab/Preppy to format reports from the table data?

Dabo uses reportlab. There's even a fully-functional Visual Report Designer. Perhaps check the screencasts first:

http://paulmcnett.com/screencasts/ReportDesignerOverview.html
http://paulmcnett.com/screencasts/ReportDesignerOverviewPartTwo.html
http://dabodev.com

···

--
pkm ~ http://paulmcnett.com

Thank you, Paul. I was leaning toward ReportLab because they have more
documentation supporting their efforts.

   The reports will be fixed in our model and no user generated, ad hoc,
reports will be available. All folks really care about are inputs and
output.

Thanks,

Rich

···

On Mon, 12 Feb 2007, Paul McNett wrote:

Dabo uses reportlab. There's even a fully-functional Visual Report Designer.

--
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

Hi Rich,

Rich Shepard wrote:

  Has anyone created a wxPython app over a database back end and used either
papyrus or ReportLab/Preppy to format reports from the table data?

I use Report Manager (http://reportman.sourceforge.net/ ) and call it from within Python using reportman.py (a ctypes wrapper of RM's ocx).

Werner

Werner F. Bruhin wrote:

I use Report Manager (http://reportman.sourceforge.net/ ) and call it from within Python using reportman.py (a ctypes wrapper of RM's ocx).

I'd like to piggyback on this topic a bit. I'm looking for alternatives to Crystal Reports; that is, reports in the typical data reporting sense (headers/footers, grouping, statistics, ...), rather than document generators. It looks like Report Manager is in this space; is that correct? Are there other OSS alternatives, or even commercial ones that integrate well with Python?

Thanks,

···

--
Don Dwiggins
Advanced Publishing Technology

Hi Don,

Don Dwiggins wrote:

Werner F. Bruhin wrote:

I use Report Manager (http://reportman.sourceforge.net/ ) and call it from within Python using reportman.py (a ctypes wrapper of RM's ocx).

I'd like to piggyback on this topic a bit. I'm looking for alternatives to Crystal Reports; that is, reports in the typical data reporting sense (headers/footers, grouping, statistics, ...), rather than document generators. It looks like Report Manager is in this space; is that correct?

I would say so. I never extensible used Crystal, so can't really compare features. The developer seems be pretty active and if ever you have something urgent you can also pay him to implement a feature.

Are there other OSS alternatives, or even commercial ones that integrate well with Python?

I think the one Dabo uses is to be considered too, at the time I looked at it did not have a report designer.

Werner

That's ReportLab. The report designer is called Platypus:

'Platypus stands for "Page Layout and Typography Using Scripts". It is a
high level page layout library which lets you programmatically create
complex documents with a minimum of effort.

'The design of Platypus seeks to separate "high level" layout decisions from
the document content as much as possible. Thus, for example, paragraphs are
constructed using paragraph styles and pages are constructed using page
templates with the intention that hundreds of documents with thousands of
pages can be reformatted to different style specifications with the
modifications of a few lines in a single shared file which contains the
paragraph styles and page layout specifications.'

Rich

···

On Tue, 13 Feb 2007, Werner F. Bruhin wrote:

I think the one Dabo uses is to be considered too, at the time I looked at
it did not have a report designer.

--
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

Rich Shepard wrote:

  That's ReportLab. The report designer is called Platypus:

'Platypus stands for "Page Layout and Typography Using Scripts". It is a
high level page layout library which lets you programmatically create
complex documents with a minimum of effort.

'The design of Platypus seeks to separate "high level" layout decisions from
the document content as much as possible. Thus, for example, paragraphs are
constructed using paragraph styles and pages are constructed using page
templates with the intention that hundreds of documents with thousands of
pages can be reformatted to different style specifications with the
modifications of a few lines in a single shared file which contains the
paragraph styles and page layout specifications.'

From this description, I gather that ReportLab is what I called a "document generator", much more multi-purpose than what I have in mind, which is focused on generating things like the typical data report with columns, subtotals, grand totals, headers and footers for report "groups", etc. Of course, one could add that capability on top of ReportLab, but I'rather not take that on if I don't have to.

···

--
Don Dwiggins
Advanced Publishing Technology

Werner F. Bruhin schrieb:

I use Report Manager (http://reportman.sourceforge.net/ ) and call it from within Python using reportman.py (a ctypes wrapper of RM's ocx).

Hi Werner!

Thank you for this valuable hint. Where can I find ``reportman.py``?
Google doesn´t find it for me.

Regards,
Gerold
:slight_smile:

···

--
________________________________________________________________________
Gerold Penz - bcom - Programmierung
     gerold.penz@tirol.utanet.at | http://gerold.bcom.at | http://sw3.at
Ehrliche, herzliche Begeisterung ist einer der
     wirksamsten Erfolgsfaktoren. Dale Carnegie

Hi Gerold,

Gerold Penz wrote:

Werner F. Bruhin schrieb:

I use Report Manager (http://reportman.sourceforge.net/ ) and call it from within Python using reportman.py (a ctypes wrapper of RM's ocx).

Hi Werner!

Thank you for this valuable hint. Where can I find ``reportman.py``?
Google doesn´t find it for me.

Nor for me anymore, maybe Oleg can give us the link - he pointed me to this some time ago.

But, I just sent a response to Chris Mellon to this list with the file attached.

Werner

Werner F. Bruhin schrieb:

But, I just sent a response to Chris Mellon to this list with the file attached.

Thank you! :slight_smile:

···

--
________________________________________________________________________
Gerold Penz - bcom - Programmierung
     gerold.penz@tirol.utanet.at | http://gerold.bcom.at | http://sw3.at
Ehrliche, herzliche Begeisterung ist einer der
     wirksamsten Erfolgsfaktoren. Dale Carnegie

Hello,

Werner F. Bruhin said the following on 14.02.2007 11:48:

Thank you for this valuable hint. Where can I find ``reportman.py``?
Google doesn´t find it for me.

Nor for me anymore, maybe Oleg can give us the link - he pointed me to this some time ago.

PyReportManager-0.1.0.zip is downloadable from the files section of yahoo reportman group:

http://tech.groups.yahoo.com/group/reportman/

But on some unknown reason this section is available only for group members...

···

--
Oleg

Oleg Deribas wrote:

Hello,

Werner F. Bruhin said the following on 14.02.2007 11:48:

Thank you for this valuable hint. Where can I find ``reportman.py``?
Google doesn´t find it for me.

Nor for me anymore, maybe Oleg can give us the link - he pointed me to this some time ago.

PyReportManager-0.1.0.zip is downloadable from the files section of yahoo reportman group:

http://tech.groups.yahoo.com/group/reportman/

But on some unknown reason this section is available only for group members...

Look at this link: Using Report Manager from Python (I got to it from the main Report Manager page, clicked on Documentation, then on the left side "Other Languages", then Python. It shows how to use the ActiveX control as well as pointing to the PyDocs for reportman.py; unfortunately, the link there to the source won't work; it's a file:// link to the C drive...

···

--
Don Dwiggins
Advanced Publishing Technology

Hi Don,

Don Dwiggins wrote:

...
Look at this link: Using Report Manager from Python (I got to it from the main Report Manager page, clicked on Documentation, then on the left side "Other Languages", then Python. It shows how to use the ActiveX control as well as pointing to the PyDocs for reportman.py; unfortunately, the link there to the source won't work; it's a file:// link to the C drive...

Just mentioned it to the developer of RM.

Werner

Hi All.

Is there any way to handle wxButton
Up & Down Event.

Thanks

Amit Tandial

*********************** Aricent-Unclassified ***********************

"DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly
prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus."

Hi Amit,

···

Amit15.Kumar@aricent.com wrote:

Hi All.
Is there any way to handle wxButton Up & Down Event.

I don't think there is a wxButton up/down event, but you could maybe use the mouse left/right up/down event.

Werner

Werner

How will i find that on which button
mouse up/down event has occured.

Since i am using Button “ABC”
…When button ABC pressed then i do something …& when it released
then i will do something different.

e.g

In Multi media player … for Fast Forward
buttun

When FF button pressed then it forward
the movie & when its up then it start playing.

Something like this i want to do.

Amit

“Werner F. Bruhin”
werner.bruhin@free.fr

02/16/2007 04:00 PM

Please respond to

wxPython-users@lists.wxwidgets.org

To

wxPython-users@lists.wxwidgets.org
cc

Subject

Re: [wxPython-users] Handling
wxButton Up/Down Event

`Hi Amit,

···

Amit15.Kumar@aricent.com wrote:

Hi All.

Is there any way to handle wxButton Up & Down Event.

I don’t think there is a wxButton up/down event, but you could maybe use

the mouse left/right up/down event.

Werner


To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwidgets.org

For additional commands, e-mail: wxPython-users-help@lists.wxwidgets.org

`

*********************** Aricent-Unclassified ***********************

"DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly
prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus."

Hi Amit,

···

Amit15.Kumar@aricent.com wrote:

Werner
How will i find that on which button mouse up/down event has occured.

Since i am using Button "ABC" ....When button ABC pressed then i do something .....& when it released then i will do something different.

e.g
In Multi media player .. for Fast Forward buttun
When FF button pressed then it forward the movie & when its up then it start playing.

Maybe you want to use a toggle button, e.g.
wx.lib.buttons.GenToggleButton
wx.lib.buttons.GenBitmapToggleButton

Werner

You need to bind to the mouse left down and mouse left up events,
rather than the button event. These would be wx.EVT_LEFT_DOWN and
wx.EVT_LEFT_UP.

···

On 2/16/07, Amit15.Kumar@aricent.com <Amit15.Kumar@aricent.com> wrote:

Werner
How will i find that on which button mouse up/down event has occured.

Since i am using Button "ABC" ....When button ABC pressed then i do something .....& when it released then i will do something different.

e.g
In Multi media player .. for Fast Forward buttun
When FF button pressed then it forward the movie & when its up then it start playing.

--

# p.d.