DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel Report JSP Exception

395671Jun 13 2003 — edited Jun 20 2003

Hello All,

I am unsuccessfully following the "Output to Excel with Oracle9i Report" tutorial found at http://otn.oracle.com/products/reports/htdocs/getstart/demonstrations/index.html to create a web-based JSP report that automatically opens in Excel within the browser. I created the template using Excel, saved this as a web page, opened this in Reports Builder, etc. Once I complete the report in Reports Builder and save it as a Reports JSP, I can successfully run this within Reports Builder using the "Run Web Layout" feature. The problem is when I try to run this JSP within my web-application in JDeveloper using the in-line reports server. The browser launches Excel, but then the ReportsTag.doStartTag() method throws a JspException (see below). Anyone seen this problem or been successful achieving this? I have a normal web-based JSP report that is running fine within JDeveloper using the reports in-line server. Also, the only way I could get my web/paper-based report to be generated in PDF format and Paginated HTML was to start a separate reports server and submit my report to the rwservlet of this server. Shouldn't I be able to use the in-line server in JDeveloper? Any help or ideas would be greatly appreciated. Thanks!

Exception I'm getting from Excel Report: javax.servlet.jsp.JspExceptionjavax.servlet.jsp.JspException
at oracle.reports.jsp.ReportTag.doStartTag(ReportTag.java:341)
at jsp.reports._schedule._Excel._jspService(_Excel.java:58)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:302)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:407)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:330)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:684)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:269)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:735)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:243)
at com.evermind.util.ThreadPoolThread.run(ThreadPoolThread.java:64)