best easy oracle report writer?

[m...@pixar.com]

I've got some simple reports to generate. It would be nice if they
could be put on the web and also generate PDFs.

These reports are for internal consumption and probably will use
just a small percentage of any software's feature set, so I would
prefer cheap and simple over complex and full featured.

Any recs appreciated, TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

[Shakespeare]

m...@pixar.com schreef:

> I've got some simple reports to generate. It would be nice if they
> could be put on the web and also generate PDFs.
>
> These reports are for internal consumption and probably will use
> just a small percentage of any software's feature set, so I would
> prefer cheap and simple over complex and full featured.
>
> Any recs appreciated, TIA!
> Mark
>

Take a look at APEX. Together with Tomcat and Cocoon you have a complete
solution at no (software) cost. Pointers to the right places at late
Carl Backstroms blog:
http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html.

and for .xls output at

http://rste.blogspot.com/2008/07/excel-export-from-apex-cocoon.html

It all may look a bit complicated, but it turned out to be quite simple
and it works perfectly.

Shakespeare

[joel garry]

Shakespeare's answer is the best, but note that sqlplus itself has
some html formatting options, and pdf converters are legion, even
probably in your local word processing software, if you want to be
really, really cheap.

I haven't looked lately, but at one point I thought the rda utility
from Oracle (the one they make you run for many SR's) had some good
examples of html formatting, and I'm sure I've seen some floating
about the web.

jg
--
@home.com is bogus.
"...there are plenty of bugs. Funnily, some them addresses issues
which seems to be mutually exclusive." - Timur Akhmadeev