Link to home
Start Free TrialLog in
Avatar of rmartes
rmartes

asked on

Oracle Reports - How to change PDF report format to Text delimited file

I have several reports that we are using that the output is in PDF, but upper management wants the raw data (Excel).  Is there a way to have report builder, send the output into a file that they can then dump into Excel?  I am currently using Oracle Report Builder v. 10.1.2.02.
Avatar of j_coreil
j_coreil
Flag of United States of America image

The easiest way that I currently do this is to define the data model in the RDF then to use BI Publisher, formally known as XML Publisher, to publish to excel. You still create the data model the same was as you do today but the output is XML. BI Publisher takes the XML format and creates a word, excel, pdf, or whatever else file for you.

Another way that you can do this is to take the SQL and have it run as a PL/SQL report which creates either the Excel file or a CSV file. There are probably ways to dump straight to excel inside the report file itself but I haven't found anything that works well for a similar problem as yourself.
ASKER CERTIFIED SOLUTION
Avatar of Sanjeev Labh
Sanjeev Labh
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial