Re: PDF/Excel Reports from Oracle RDF files

[Quoted] Hi Srinivas -

The project I'm working on uses Oracle Report Server 6i in conjunction with [Quoted] 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 - 05:24:30 CEST