Report designer

[Joril]

Hi everyone!
I'm looking for a tool like Crystal reports or Visual Foxpro's report designer that would enable me to print from a wxWidgets C++ program while fetching data from a DB or a ResultSet..
I googled a little and came across Report Manager (http://reportman.sourceforge.net), but it's QT-binded (at least if you want preview capabilities) and I'd like to keep my application as dependency-free as possible..
Is there some alternative? Something like what Jasper reports does for Java would be perfect..
Many thanks for your time

[Michalis Kabrianis]

Post by Joril
Hi everyone!
I'm looking for a tool like Crystal reports or Visual Foxpro's report designer that would enable me to print from a wxWidgets C++ program while fetching data from a DB or a ResultSet..
I googled a little and came across Report Manager (http://reportman.sourceforge.net), but it's QT-binded (at least if you want preview capabilities) and I'd like to keep my application as dependency-free as possible..
Is there some alternative? Something like what Jasper reports does for Java would be perfect..
Many thanks for your time

...

Hi
I haven't seen any such component although I would like to find one...
I have found that functionality though in Kirix Strata (I downloaded the
evaluation version and I can only say: Wow!!!)
Maybe you could talk with them to sublicense that component (if such an
option exists).

Michalis

[Milan Babuskov]

Post by Joril
I'm looking for a tool like Crystal reports or Visual Foxpro's report designer that would enable me to print from a wxWidgets C++ program while fetching data from a DB or a ResultSet..
I googled a little and came across Report Manager (http://reportman.sourceforge.net), but it's QT-binded (at least if you want preview capabilities) and I'd like to keep my application as dependency-free as possible..
Is there some alternative? Something like what Jasper reports does for Java would be perfect..
Many thanks for your time

...

I wrote a very simple code that dumps data from database to
wxHtmlWindow. I simply print it from there.

Formatting HTML is really easy.

HTH

[Joril]

On Wed, 23 Feb 2005 15:54:20 +0000 (UTC)

Post by Milan Babuskov
I wrote a very simple code that dumps data from database to
wxHtmlWindow. I simply print it from there.
Formatting HTML is really easy.

I see :)
Mmh.. But what about page breaks? Such as.. Redisplaying column headers on the top on every new page? You handle that too?

[Juergen Geltinger]

Post by Milan Babuskov
I wrote a very simple code that dumps data from database to
wxHtmlWindow. I simply print it from there.
Formatting HTML is really easy.

I see :) Mmh.. But what about page breaks? Such as.. Redisplaying
column headers on the top on every new page? You handle that too?

Do you know wxRepWrt ?

http://www.daily.de/RepWrt/

HTH,

Juergen

[Joril]

On Thu, 24 Feb 2005 06:04:39 +0000 (UTC)

Post by Juergen Geltinger
Do you know wxRepWrt ?
http://www.daily.de/RepWrt/

Yes, I did try that too, many thanks for the great tool :)
Still, I'd like to know if there's something more GUI-oriented, like VFP's report designer, as I said... If it exists, of course ^^
(I know, using wxHtml* _wouldn't_ be very "GUI-oriented", I was just.. Ehr.. Investigating Milan's solution ^__^; )
Thanks for the tip all the same!

[Keith Davies]

Post by Joril
Hi everyone!
I'm looking for a tool like Crystal reports or Visual Foxpro's report designer that would enable me to print from a wxWidgets C++ program while fetching data from a DB or a ResultSet..
I googled a little and came across Report Manager (http://reportman.sourceforge.net), but it's QT-binded (at least if you want preview capabilities) and I'd like to keep my application as dependency-free as possible..
Is there some alternative? Something like what Jasper reports does for Java would be perfect..
Many thanks for your time

...

I don't have a GUI-oriented solution. However, on a recent project I
had to develop reports with data coming out of an Access database. The
easy way -- the easiest I found to meet my requirements -- was:

. Access stores data
. wx app (using OTL[1] rather than wxODBC) pulls data out of Access and
writes an XML file[2]
. XSLT transformations from XML to another XML (aggregate information
from sections of the report, rather than run multiple queries in C++)
to XSL-FO + SVG (Formatting Objects for page layout, SVG for the
charts needed)
. FOP on the XSL-FO + SVG to make PDF

It was all hand-rolled, some of it in great haste (changes to user
requirements, dammit), but fairly easy to work with. *UNLIKE* the GUI-
oriented solutions, there was no macdinking required to get things to
line up, change column widths, etc. (my biggest beef with Crystal
Reports and the like, the amount of tiny manual changes that have to be
made to the report definitions... well, that, and being limited in how
they can fetch and manipulate data).

Toward the end of the project, I could throw together reports faster
(and better-looking) using these techniques than I was ever able to do
with Crystal Reports. With a bit more design and development I could
probably even build something a little more general purpose -- store
queries in data, describe in data how to manipulate the data for the
purpose of the report, etc.

(Part of the reason this was the easy way was because Access doesn't do
charts well... there *is* a component that should do it, but buggered if
I could ever figure out how to make it work without pain.)

[1] OTL == {Oracle|ODBC} Template Library: http://otl.sf.net
[2] Access can output XML for tables and queries, but I didn't have that
set up -- and couldn't rely on having the same version of Access
available at the client site. So: wx client to suck the data out of
the database and write XML


Keith