Re: PDF/Excel Reports from Oracle RDF files

Thanks Carla for the input. But Oracle is removing support for Report server and it will be made part of App server. Even if we wanted to use report generation for web, we would like it to be available as a component rather than as a server itself, which needs lot more hw/sw/maintenance/integration pains with other Web servers.

So we are looking for cost effective way of supporting report generation funtionality with c/s interface, without much additional hw and sw.

If someone can give us a small tool to read Oracle RDF/REX/XML report format files and generate PDF/Excel (with client or server interface), then it will be great!

Srinivas

"Carla" <csteinme_at_yahoo.com> wrote in message news:O5p%8.86361$DS.2758423_at_twister.tampabay.rr.com...
> Hi Srinivas -
>
> The project I'm working on uses Oracle Report Server 6i in conjunction
with
> Oracle OAS 4.08 (someday we will move to iAS, but I'm sure the concept is
> the same) to generate the pdf and excel files over the web. The Report
> Server will generate the pdf files with a few runtime parameters set, but
> you will need to do a little fancy footwork to download to excel. We've
> used an implementation with a java servlet and a pl/sql package to set the
> mime type to excel, grab the sql query from the v$sql table, dynamically
> bind the variables, and format it for excel. {*whew*}
>
> It works, and we've converted about 50 reports to work this way. Even
> charts will display nicely in the pdf format.
>
> Carla
>
> "Chowdary" <ps_chowdary_at_hotmail.com> wrote in message
> news:IZn%8.207755$DB.5981392_at_news1.east.cox.net...
> > Hi all,
> >
> > We have RDF format Oracle report files and need to use them to
> > generate PDF/Excel files from VB/C++ client or UNIX servers. As I
> understand
> > Oracle
> > is removing support for client/server support for report generation
> > tools and pushing users to Oracle App server. But we do not want to
> > use Oracle App Server for this report generation purpose.
> >
> > Can anyone please point to 3rd party tool for using RDF to generate
> > PDF/Excel files?
> >
> > May be we can even convert RDF to XML (as per Oracle Reports DTD).
> > Then we need some tool to consume these XML files and generate
> > PDF/Excel files.
> >
> > thanks,
> > Srinivas
> >
> >
> >
>
>
Received on Wed Jul 24 2002 - 06:19:47 CEST