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