Oracle Reports in Excel format

The Explorer

Hi ,

The environment of my company consist of an ERP system developed using Oracle Forms 4.5 and Reports 2.5. Now, due to increase in business activities, there is a lot of requests from user for reports in Excel sheet.

Our company is planning for Oracle ERP Rel 12....and it is under process of analysis..due to which there is no chance of upgrade to latest Developer Suite.

As of now, to fulfill user requirements of Excel based reports...what do you think is best and permanent solution?
Is there any plug-in or Business Process or Business Intelligence application llike ORACLE BI Spreadsheet plug-in..which meets our demand.

Please suggest ....As of now provide users with options to run the report and generate output in HTML format, from there, they copy it to Excel..but this process is not at all user friendly and feasible.

I appreciate your valuable suggestions.


Thanks.
O M E R

Marwim

Hello Omer,

we use Oracle Reports for generating PDF reports, but to generate Excel files we use a free implementation of Microsofts XML-spreadsheet format. In my eyes the best solutions are
https://xml-spreadsheet.samplecode.oracle.com/ or
https://exceldocumenttype.samplecode.oracle.com/
Others can be found at 2516584

Regards
Marcus

DC

If you can upgrade Reports to higher version, you can get Excel output from Reports directly, such as ...

http://www.oracle.com/webapps/online-help/reports/10.1.2/topics/htmlhelp_rwbuild_hs/rwwhthow/whatare/output/output_a_simpleexcel.htm

The Explorer

I appreciate your valuable response.

Your one response includes multiple solutions.

Thanks,
O M E R

The Explorer

Thanks for the information.

Due to ongoing ERP implementation, I cannot upgrade.

Thanks,
O M E R

744363

Omer,
You can use the third-party tool rep2excel from the www.lv2000.com site. I will convert your report's output in excel.

HTH,

Regards,
Yousuf