Oracle Reports

user10991018

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

Hi

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

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.