Thread: reporting tools
We are looking for a reporting tool that will enable users to generate their own reports. Something like Crystal Reports. Anyone using something like this with Postgresql? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Geoffrey wrote:
> We are looking for a reporting tool that will enable users to generate
> their own reports. Something like Crystal Reports.
>
> Anyone using something like this with Postgresql?
>
Why not Crystal Reports?
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGzMDnATb/zqfZUUQRAnFVAJ9DJuRS9fC9lxYLprFjJDksZooa0QCfTact
hyg0jWPxREKbcYMblS/0fp4=
=Z38E
-----END PGP SIGNATURE-----
Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Geoffrey wrote: >> We are looking for a reporting tool that will enable users to generate >> their own reports. Something like Crystal Reports. >> >> Anyone using something like this with Postgresql? >> > > Why not Crystal Reports? My bad. We are looking for an open source reporting tool that will enable users to generate their own reports. Something like Crystal Reports. ;) -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
On 8/22/07, Joshua D. Drake <jd@commandprompt.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Geoffrey wrote: > > We are looking for a reporting tool that will enable users to generate > > their own reports. Something like Crystal Reports. > > > > Anyone using something like this with Postgresql? > > > > Why not Crystal Reports? Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL for quite some time now. We had it hitting a pg7.2 db back in the day, when hip kids road around in rag top roadsters and wore tshirts with cigarettes rolled in their sleeves. Also, look at Pentaho. It's open source and pretty good.
On Aug 22, 2007, at 7:21 PM, Geoffrey wrote: > We are looking for an open source reporting tool that will enable > users to generate their own reports. Something like Crystal > Reports. ;) I was looking at a couple the other day: iReport (part of Jasper), OpenRPT, and DataVision (http://datavision.sourceforge.net/). The DataVision page has some links to other report writers. Hopefully you'll do better than I did -- I also wanted something that works on OS X. All of the above meet that criteria by using Java or GTK, but the user interfaces are hard to take if you want a typical Mac application. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John DeSoi wrote: > > On Aug 22, 2007, at 7:21 PM, Geoffrey wrote: > >> We are looking for an open source reporting tool that will enable >> users to generate their own reports. Something like Crystal Reports. ;) > > I was looking at a couple the other day: iReport (part of Jasper), > OpenRPT, and DataVision (http://datavision.sourceforge.net/). The > DataVision page has some links to other report writers. Hopefully you'll > do better than I did -- I also wanted something that works on OS X. All > of the above meet that criteria by using Java or GTK, but the user > interfaces are hard to take if you want a typical Mac application. MS Access? Joshua D. Drake > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGzN5PATb/zqfZUUQRAgm0AKCCqXpYK0lj4nO6wgF/N4aiLqfHVwCglB1U mdN7zbzfOZ6/9SKE3xcLi/M= =LCrl -----END PGP SIGNATURE-----
On 23/08/07, Scott Marlowe <scott.marlowe@gmail.com> wrote: > > Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL > for quite some time now. We had it hitting a pg7.2 db back in the > day, when hip kids road around in rag top roadsters and wore tshirts > with cigarettes rolled in their sleeves. > > Also, look at Pentaho. It's open source and pretty good. Thanks. Pentaho looks good. But are there any alternatives that don't require me to spend days installing the whole Java shebang?
On Thu, 2007-08-23 at 16:42 +0800, Phoenix Kiula wrote: > On 23/08/07, Scott Marlowe <scott.marlowe@gmail.com> wrote: > > > > Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL > > for quite some time now. We had it hitting a pg7.2 db back in the > > day, when hip kids road around in rag top roadsters and wore tshirts > > with cigarettes rolled in their sleeves. > > > > Also, look at Pentaho. It's open source and pretty good. > > > > Thanks. Pentaho looks good. But are there any alternatives that don't > require me to spend days installing the whole Java shebang? > my 2 cents.. I've tried to install and play with pentaho like more than a couple of times and failed each time. There was just some java errors which I didn't comprehend and this is from it's all-in-one package.
Phoenix Kiula wrote on 23.08.2007 10:42: > On 23/08/07, Scott Marlowe <scott.marlowe@gmail.com> wrote: >> Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL >> for quite some time now. We had it hitting a pg7.2 db back in the >> day, when hip kids road around in rag top roadsters and wore tshirts >> with cigarettes rolled in their sleeves. >> >> Also, look at Pentaho. It's open source and pretty good. > > > > Thanks. Pentaho looks good. But are there any alternatives that don't > require me to spend days installing the whole Java shebang? If you don't need a server-based solution, you might want to look at iReport designer. Although it is also Java based it only needs a runtime environment on the client (not sure if that qualifies for "whole shebang" for you as well): http://www.jasperforge.org/sf/projects/ireport Thomas
Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > John DeSoi wrote: >> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote: >> >>> We are looking for an open source reporting tool that will enable >>> users to generate their own reports. Something like Crystal Reports. ;) >> I was looking at a couple the other day: iReport (part of Jasper), >> OpenRPT, and DataVision (http://datavision.sourceforge.net/). The >> DataVision page has some links to other report writers. Hopefully you'll >> do better than I did -- I also wanted something that works on OS X. All >> of the above meet that criteria by using Java or GTK, but the user >> interfaces are hard to take if you want a typical Mac application. > > MS Access? Gag, cough, choke.... -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Thanks for the various responses, I'll check them out and post my research results and our decision. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
On Thu, 2007-08-23 at 06:20 -0400, Geoffrey wrote: > Joshua D. Drake wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > John DeSoi wrote: > >> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote: > >> > >>> We are looking for an open source reporting tool that will enable > >>> users to generate their own reports. Something like Crystal Reports. ;) > >> I was looking at a couple the other day: iReport (part of Jasper), > >> OpenRPT, and DataVision (http://datavision.sourceforge.net/). The > >> DataVision page has some links to other report writers. Hopefully you'll > >> do better than I did -- I also wanted something that works on OS X. All > >> of the above meet that criteria by using Java or GTK, but the user > >> interfaces are hard to take if you want a typical Mac application. > > > > MS Access? > > Gag, cough, choke.... Ah, no, sorry. Gag and cough only run on an Amiga, and choke went EOL with MSDOS 6.2 ;-)
On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote: > We are looking for a reporting tool that will enable users to generate > their own reports. Something like Crystal Reports. > > Anyone using something like this with Postgresql? > agata, datavision, jasper reports, birt, openRPT -- google shows numerous results
On 8/23/2007 5:16 AM Thomas Kellerer wrote: > Phoenix Kiula wrote on 23.08.2007 10:42: >> On 23/08/07, Scott Marlowe <scott.marlowe@gmail.com> wrote: >>> Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL >>> for quite some time now. We had it hitting a pg7.2 db back in the >>> day, when hip kids road around in rag top roadsters and wore tshirts >>> with cigarettes rolled in their sleeves. >>> >>> Also, look at Pentaho. It's open source and pretty good. >> >> >> >> Thanks. Pentaho looks good. But are there any alternatives that don't >> require me to spend days installing the whole Java shebang? > > If you don't need a server-based solution, you might want to look at > iReport designer. > > Although it is also Java based it only needs a runtime environment on > the client (not sure if that qualifies for "whole shebang" for you as > well): This is specifically why we released OpenRPT as open source - it's very lightweight, no Java required. http://sf.net/projects/openrpt Cheers, Ned -- Ned Lilly President and CEO xTuple 119 West York Street Norfolk, VA 23510 tel. 757.461.3022 x101 email: ned@xtuple.com www.xtuple.com
Ned Lilly wrote on 23.08.2007 15:44: > This is specifically why we released OpenRPT as open source - it's very > lightweight, no Java required. http://sf.net/projects/openrpt I am a Java developer and thus I have no problems in using Java based tools. Especially because I ususally only have a JDBC driver for the databases I use around (especially with Oracle this is *very* nice, because it does not require a full client install, only a single .jar file) But OpenRPT looks quite nice, I'll have a look at it as well. I guess I need to install the whole ODBC "shebang" for that, right :) Thomas
I looked at BIRT - it is part of Eclipse. It is pretty new and I found the documentation to be pretty limited. Also, it has few output options. These factors caused me to decide against it. Settled on JasperReports and like it a lot. It integrated easily with my Java (Eclipse RCP) GUI. Creating reports isn't any harder than Crystal Reports. In my GUI, I use an xml file for a report list, so I can add, edit, and delete reports easily without altering program code.
Michael Schmidt
----- Original Message -----From: Reid ThompsonTo: GeoffreySent: Thursday, August 23, 2007 7:35 AMSubject: Re: [GENERAL] reporting tools
On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote:
> We are looking for a reporting tool that will enable users to generate
> their own reports. Something like Crystal Reports.
>
> Anyone using something like this with Postgresql?
>
agata, datavision, jasper reports, birt, openRPT -- google shows
numerous results
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
On 8/23/2007 10:07 AM Thomas Kellerer wrote: > Ned Lilly wrote on 23.08.2007 15:44: >> This is specifically why we released OpenRPT as open source - it's >> very lightweight, no Java required. http://sf.net/projects/openrpt > > I am a Java developer and thus I have no problems in using Java based > tools. Especially because I ususally only have a JDBC driver for the > databases I use around (especially with Oracle this is *very* nice, > because it does not require a full client install, only a single .jar file) > > But OpenRPT looks quite nice, I'll have a look at it as well. I guess I > need to install the whole ODBC "shebang" for that, right :) Heh. Actually, no, there's a native Postgres connection as well. And you can compile it with any other native db driverprovided by Qt (but why on earth would anyone want to use any other db ;-) Cheers, Ned -- Ned Lilly President and CEO xTuple 119 West York Street Norfolk, VA 23510 tel. 757.461.3022 x101 email: ned@xtuple.com www.xtuple.com
If query development is an important part of what you need to do, consider dbQwikEdit. It's not open or free. But you can get a minimal config for free (I think) and it's pretty cheap copnsidering what it can do. It uses ODBC and can read any DB that ODBC points to (Oracle, MySQL, Postgres, SQLServer, etc...). You can enter your queries in by hand (being the sql savy people we are, that's what we'd do). But there is also a GUI that users can run that'll hand-hold them through building SQL using graphics. Pretty neat. This feature allows users to run "ad-hoc". THe output is just tabular. But you can export to lots of different formats. Just a thought. http://www.dbqwikedit.com/ -dave -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thomas Kellerer Sent: Thursday, August 23, 2007 10:07 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] reporting tools Ned Lilly wrote on 23.08.2007 15:44: > This is specifically why we released OpenRPT as open source - it's very > lightweight, no Java required. http://sf.net/projects/openrpt I am a Java developer and thus I have no problems in using Java based tools. Especially because I ususally only have a JDBC driver for the databases I use around (especially with Oracle this is *very* nice, because it does not require a full client install, only a single .jar file) But OpenRPT looks quite nice, I'll have a look at it as well. I guess I need to install the whole ODBC "shebang" for that, right :) Thomas ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Use www.fyireporting.com Open source, uses excellent PostgreSQL npgsql drivers. Use standard RDL format Andrus. "Geoffrey" <lists@serioustechnology.com> kirjutas s�numis news:46CCBF59.2090806@serioustechnology.com... > We are looking for a reporting tool that will enable users to generate > their own reports. Something like Crystal Reports. > > Anyone using something like this with Postgresql? > > -- > Until later, Geoffrey > > Those who would give up essential Liberty, to purchase a little > temporary Safety, deserve neither Liberty nor Safety. > - Benjamin Franklin > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Andrus wrote: > Use > > www.fyireporting.com > > Open source, uses excellent PostgreSQL npgsql drivers. > Use standard RDL format I guess I should have noted that we will need to run this on Linux clients. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
> I guess I should have noted that we will need to run this on Linux > clients. Geoffrey, You can run FYIReporting engine in Linux using MONO ( www.go-mono.com ) Andrus.
Andrus wrote: >> I guess I should have noted that we will need to run this on Linux >> clients. > > Geoffrey, > > You can run FYIReporting engine in Linux using MONO ( www.go-mono.com ) Thanks, we're looking for something that will run natively on Linux. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Geoffrey <lists@serioustechnology.com> wrote: > > Andrus wrote: > >> I guess I should have noted that we will need to run this on Linux > >> clients. > > > > Geoffrey, > > > > You can run FYIReporting engine in Linux using MONO ( www.go-mono.com ) > > Thanks, we're looking for something that will run natively on Linux. I read this, almost deleted it, read it again ... Just in case there's confusion, MONO + FYIReporting _is_ native on Linux. At least, as much so as Java on Linux is. -- Bill Moran http://www.potentialtech.com
Bill Moran wrote: > Geoffrey <lists@serioustechnology.com> wrote: >> Andrus wrote: >>>> I guess I should have noted that we will need to run this on Linux >>>> clients. >>> Geoffrey, >>> >>> You can run FYIReporting engine in Linux using MONO ( www.go-mono.com ) >> Thanks, we're looking for something that will run natively on Linux. > > I read this, almost deleted it, read it again ... > > Just in case there's confusion, MONO + FYIReporting _is_ native on Linux. > > At least, as much so as Java on Linux is. We are not interested in using any Microsoft technologies, or technologies based on Microsoft technologies. It's a philosophical position. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
On 10/14/2007 6:41 PM Geoffrey wrote: > Bill Moran wrote: >> Geoffrey <lists@serioustechnology.com> wrote: >>> Andrus wrote: >>>>> I guess I should have noted that we will need to run this on Linux >>>>> clients. >>>> Geoffrey, >>>> >>>> You can run FYIReporting engine in Linux using MONO ( www.go-mono.com ) >>> Thanks, we're looking for something that will run natively on Linux. >> >> I read this, almost deleted it, read it again ... >> >> Just in case there's confusion, MONO + FYIReporting _is_ native on Linux. >> >> At least, as much so as Java on Linux is. > > We are not interested in using any Microsoft technologies, or > technologies based on Microsoft technologies. > > It's a philosophical position. Geoffrey, have you looked at OpenRPT? http://sourceforge.net/projects/openrpt
Ned Lilly wrote: > On 10/14/2007 6:41 PM Geoffrey wrote: >> Bill Moran wrote: >>> Geoffrey <lists@serioustechnology.com> wrote: >>>> Andrus wrote: >>>>>> I guess I should have noted that we will need to run this on Linux >>>>>> clients. >>>>> Geoffrey, >>>>> >>>>> You can run FYIReporting engine in Linux using MONO ( >>>>> www.go-mono.com ) >>>> Thanks, we're looking for something that will run natively on Linux. >>> >>> I read this, almost deleted it, read it again ... >>> >>> Just in case there's confusion, MONO + FYIReporting _is_ native on >>> Linux. >>> >>> At least, as much so as Java on Linux is. >> >> We are not interested in using any Microsoft technologies, or >> technologies based on Microsoft technologies. >> >> It's a philosophical position. > > > Geoffrey, have you looked at OpenRPT? > > http://sourceforge.net/projects/openrpt Yes, and it is looking like the app we will be going with. Thanks. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Can you clarify the need / value added for reporting tool, over just running queries and packaging the output in HTML (with a little CSS for styling, you can get near PDF quality). This can be done in SQL and a tad of PHP (or Ruby).
On 10/15/07, Geoffrey <lists@serioustechnology.com> wrote:
Ned Lilly wrote:
> On 10/14/2007 6:41 PM Geoffrey wrote:
>> Bill Moran wrote:
>>> Geoffrey <lists@serioustechnology.com> wrote:
>>>> Andrus wrote:
>>>>>> I guess I should have noted that we will need to run this on Linux
>>>>>> clients.
>>>>> Geoffrey,
>>>>>
>>>>> You can run FYIReporting engine in Linux using MONO (
>>>>> www.go-mono.com )
>>>> Thanks, we're looking for something that will run natively on Linux.
>>>
>>> I read this, almost deleted it, read it again ...
>>>
>>> Just in case there's confusion, MONO + FYIReporting _is_ native on
>>> Linux.
>>>
>>> At least, as much so as Java on Linux is.
>>
>> We are not interested in using any Microsoft technologies, or
>> technologies based on Microsoft technologies.
>>
>> It's a philosophical position.
>
>
> Geoffrey, have you looked at OpenRPT?
>
> http://sourceforge.net/projects/openrpt
Yes, and it is looking like the app we will be going with. Thanks.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
On Mon, 2007-10-15 at 23:59 -0400, Robert James wrote: > Can you clarify the need / value added for reporting tool, over just > running queries and packaging the output in HTML (with a little CSS > for styling, you can get near PDF quality). This can be done in SQL > and a tad of PHP (or Ruby). > Not all users w/ have like to see pre-prepared queries. Some will have extra requirements eg: slice the data etc. So, in these circumstances, drill down is very important. >
Robert James wrote: > Can you clarify the need / value added for reporting tool, over just running > queries and packaging the output in HTML (with a little CSS for styling, you > can get near PDF quality). This can be done in SQL and a tad of PHP (or > Ruby). Looking at having someone generate reports which a gui that requires no more then sql knowledge. > > On 10/15/07, Geoffrey <lists@serioustechnology.com> wrote: >> Ned Lilly wrote: >>> On 10/14/2007 6:41 PM Geoffrey wrote: >>>> Bill Moran wrote: >>>>> Geoffrey <lists@serioustechnology.com> wrote: >>>>>> Andrus wrote: >>>>>>>> I guess I should have noted that we will need to run this on Linux >>>>>>>> clients. >>>>>>> Geoffrey, >>>>>>> >>>>>>> You can run FYIReporting engine in Linux using MONO ( >>>>>>> www.go-mono.com ) >>>>>> Thanks, we're looking for something that will run natively on Linux. >>>>> I read this, almost deleted it, read it again ... >>>>> >>>>> Just in case there's confusion, MONO + FYIReporting _is_ native on >>>>> Linux. >>>>> >>>>> At least, as much so as Java on Linux is. >>>> We are not interested in using any Microsoft technologies, or >>>> technologies based on Microsoft technologies. >>>> >>>> It's a philosophical position. >>> >>> Geoffrey, have you looked at OpenRPT? >>> >>> http://sourceforge.net/projects/openrpt >> Yes, and it is looking like the app we will be going with. Thanks. >> >> >> -- >> Until later, Geoffrey >> >> Those who would give up essential Liberty, to purchase a little >> temporary Safety, deserve neither Liberty nor Safety. >> - Benjamin Franklin >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match >> > -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin