Home » Developer & Programmer » Forms » Running JSP Excel report from Forms 10g (Forms 10g)
Running JSP Excel report from Forms 10g [message #289098] Wed, 19 December 2007 12:53 Go to next message
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
Re: Running JSP Excel report from Forms 10g [message #289175 is a reply to message #289098] Wed, 19 December 2007 23:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Quote:

We can't use just web.show_document alone since quite a few parameters need to be passed.
What message is being shown?

Please look at:
http://www.orafaq.com/forum/m/144539/67467/?srch=web.show_document#msg_144539

Please post your code.

David
Previous Topic: print form
Next Topic: How to get function keys to work in a modal window
Goto Forum:
  


Current Time: Tue Dec 06 02:53:55 CST 2016

Total time taken to generate the page: 0.09259 seconds