DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Reports

user10991018Jan 20 2020 — edited Feb 13 2020

Hi I have a requirement of creating an oracle report which should be in excel format.

i called the report from a parameter form in excel format by setting the form report property

Report Destination Format = SPREADSHEET

able to open the report and get the data correctly but there is not headers and footer displayed in my report.

if i open the report in .pdf format i am able to get the header and footer but when opening in excel format the header and footer is not displaying.

can you please advise.

thanks.

Software details

Oracle 11g.

Forms 11g

Report Builder 11.1.1.7.0

Suresh Sangaran-Oracle

desformat=spreadsheet can display objects only in the body area of Header, Main and footer sections. If the Header/footer sections is in the margin area then it wont display.

Thanks - Suresh

1 person found this helpful

Alexey Shmelev

In my company the only workable and decently looking solution was an Excel converter that took specifically formatted reports generated by Oracle Reports in DELIMITEDDATA format and converted them into XLSX using Apache POI.

DevOps, CI/CD and Automation

Oracle Reports

Comments

Post Details