Running JSP Excel report from Forms 10g [message #289098] |
Wed, 19 December 2007 12:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
MaxineK
Messages: 1 Registered: December 2007
|
Junior Member |
|
|
Hello,
We have a JSP report that displays data in MS Excel. Works fine if called from the url.
The report shall be called from the form passing a parameter list with PARAMFORM=NO.
Problem: reports runs as designed but opens up an empty Excel spreadsheet. No errors, no data..
We are using RUN_REPORT_OBJECT with desformat=spreadsheet and paramform=no.
We can't use just web.show_document alone since quite a few parameters need to be passed.
I've read in one of the posts that a paper layout need to be created (in addition to web layout) to run RUN_REPORT_OBJECT. Done that, but now it does not open EXCEL, and displays paper layout in a browser.
So, how to call JSP (Excel) report from Forms passing parameter list without displaying the parameter form?
Thank you
|
|
|
|