Hi, I've been trying out numerous ways on how to output a Report's Concurrent Request as an Excel File. The farthest i've gone so far was to set the concurrent request output to XML, then define two viewers for XML (Excel and Browser). After that, i run the request, i get an excel file that has XML formatting.
Link here: http://apps2fusion.com/apps/apps/166-how-to-open-using-excel-spreadsheets-directly-from-the-concurrent-request
I've seen a way that the report outputs to excel embedded in the browser using the DESFORMAT=SPREADSHEET method.
However, i can't figure out how/where to set DESFORMAT. Is it called programatically? should i set it a user parameter? (i've seen it as a system parameter, i've had no experience in setting system parameters).
Last thing, i've seen from Install > Viewer Options that there is an "Excel" File Format but it does not appear in the selection of output format in the Concurrent Request Form.
Would appreciate any feedback on this. It's kinda urgent.
Been digging the internet all day but to no avail.
Using
- Oracle Reports Builder 10g,
- Oracle Database 11.2.0.3.0
- Oracle Applications 12.1.3
- Windows 7 x86
- Internet Explorer 9
- MS Excel 2010
Thank you!