Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Error while running web layout report with Oracle Reports Builder in Oracle Developer Suite 10g

Posted on 2009-07-08
4
Medium Priority
?
3,269 Views
Last Modified: 2013-12-19
I am a starter in Oracle Reports. I am using oracle report builder in oracle developer suite 10g. When i tried to generate report in both paper and web layouts, i am able to run paper layout but I am getting an error when i am running web layout. I saved that report as .jsp file type. I am using Oracle 10g Database. I am also attaching the screenshot of that error in browser and websource code.

Can anyone help me to overcome this error..
WEB SOURCE CODE FOR THAT REPORT
 
 
<%@ taglib uri="/WEB-INF/lib/reports_tld.jar" prefix="rw" %>
<%@ page language="java" import="java.io.*" errorPage="/rwerror.jsp" session="false" %>
<!--
<rw:report id="report">
<rw:objects id="objects">
</rw:objects>
-->
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 
<HTML>
 
<HEAD>
  <TITLE> Your Title </TITLE>
  <rw:style id="rwblue118">
<link rel="StyleSheet" type="text/css" href="css/rwblue.css">
</rw:style>
 
  <META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</HEAD>
 
<BODY bgColor="#ffffff" link="#000000" vLink="#000000">
 
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
  <TBODY>
  <TR>
    <TD bgColor="#ffffff" rowSpan=2 vAlign=middle width=188><IMG alt="" src="images/rwblue_logo.gif" width="135" height="36"></TD>
    <TD bgColor="#ffffff" height=40 vAlign=top><IMG alt="" height=1 src="images/stretch.gif" width=5></TD>
    <TD align=right bgColor="#ffffff" vAlign=bottom>&nbsp;</TD>
  </TR>
  </TBODY>
</TABLE>
 
<TABLE bgColor="#ff0000" border=0 cellPadding=0 cellSpacing=0 width="100%">
  <TBODY>
  <TR>
    <TD bgColor="#ff0000" class="OraColumnHeader">&nbsp;</TD>
  </TR>
  </TBODY>
</TABLE>
 
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
  <TBODY>
  <TR>
    <TD bgColor="#ff0000" vAlign=top class="OraColumnHeader"><IMG alt="" border=0 height=17 src="images/topcurl.gif" width=30></TD>
    <TD vAlign=top width="100%">
      <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
        <TBODY>
        <TR>
          <TD bgColor="#000000" height=1><IMG alt="" border=0 height=1 src="images/stretch.gif" width=1></TD>
        </TR>
        <TR>
          <TD bgColor="#9a9c9a" height=1><IMG alt="" border=0 height=1 src="images/stretch.gif" width=1></TD>
        </TR>
        <TR>
          <TD bgColor="#b3b4b3" height=1><IMG alt="" border=0 height=1 src="images/stretch.gif" width=1></TD>
        </TR>
        </TBODY>
      </TABLE>
    </TD>
  </TR>
  </TBODY>
</TABLE>
 
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
  <TR>
    <TD width="29%" valign="top">
      <TABLE width="77%" border="0" cellspacing="0" cellpadding="0">
        <TR>
          <TD width="10%" class="OraCellText"><IMG alt="" src="images/blue_d_arrow.gif" width="10" height="10"></TD>
          <TD width="90%" class="OraCellText">Navigation goes here </TD>
        </TR>
        <TR>
          <TD width="10%" class="OraCellText"><IMG alt="" src="images/blue_r_arrow.gif" width="10" height="10"></TD>
          <TD width="90%" class="OraCellText">Navigation Item</TD>
        </TR>
      </TABLE>
    </TD>
    <TD width="71%">
      <DIV align="center">
      <!-- Data Area Generated by Reports Developer -->
<rw:dataArea id="MG1GRPFR106">
<table class="OraTable">
<caption>  </caption>
 <!-- Header -->
 <thead>
  <tr>
   <th <rw:id id="HBempno106" asArray="no"/> class="OraColumnHeader"> Empno </th>
   <th <rw:id id="HBENAME106" asArray="no"/> class="OraColumnHeader"> Ename </th>
   <th <rw:id id="HBENAME1106" asArray="no"/> class="OraColumnHeader"> Ename1 </th>
   <th <rw:id id="HBDEPTNO106" asArray="no"/> class="OraColumnHeader"> Deptno </th>
   <th <rw:id id="HBSAL106" asArray="no"/> class="OraColumnHeader"> Sal </th>
   <th <rw:id id="HBCOMM106" asArray="no"/> class="OraColumnHeader"> Comm </th>
  </tr>
 </thead>
 <!-- Body -->
 <tbody>
  <rw:foreach id="RG11061" src="G_1">
   <tr>
    <td <rw:headers id="HFempno106" src="HBempno106"/> class="OraCellNumber"><rw:field id="Fempno106" src="empno" nullValue="&nbsp;"> F_empno </rw:field></td>
    <td <rw:headers id="HFENAME106" src="HBENAME106"/> class="OraCellText"><rw:field id="FENAME106" src="ENAME" nullValue="&nbsp;"> F_ENAME </rw:field></td>
    <td <rw:headers id="HFENAME1106" src="HBENAME1106"/> class="OraCellText"><rw:field id="FENAME1106" src="ENAME1" nullValue="&nbsp;"> F_ENAME1 </rw:field></td>
    <td <rw:headers id="HFDEPTNO106" src="HBDEPTNO106"/> class="OraCellNumber"><rw:field id="FDEPTNO106" src="DEPTNO" nullValue="&nbsp;"> F_DEPTNO </rw:field></td>
    <td <rw:headers id="HFSAL106" src="HBSAL106"/> class="OraCellNumber"><rw:field id="FSAL106" src="SAL" nullValue="&nbsp;"> F_SAL </rw:field></td>
    <td <rw:headers id="HFCOMM106" src="HBCOMM106"/> class="OraCellNumber"><rw:field id="FCOMM106" src="COMM" nullValue="&nbsp;"> F_COMM </rw:field></td>
   </tr>
  </rw:foreach>
 </tbody>
 <!-- Report Level Summary -->
 <tr>
  <th class="OraTotalText"> &nbsp; </th>
  <th class="OraTotalText"> &nbsp; </th>
  <th class="OraTotalText"> &nbsp; </th>
  <th class="OraTotalText"> &nbsp; </th>
  <td <rw:headers id="HFSumSALPerReport106" src="HBSAL106"/> class="OraTotalNumber">Total: <rw:field id="FSumSALPerReport106" src="SumSALPerReport" nullValue="&nbsp;"> F_SumSALPerReport </rw:field></td>
  <td <rw:headers id="HFSumCOMMPerReport106" src="HBCOMM106"/> class="OraTotalNumber">Total: <rw:field id="FSumCOMMPerReport106" src="SumCOMMPerReport" nullValue="&nbsp;"> F_SumCOMMPerReport </rw:field></td>
 </tr>
 <tr>
  <th class="OraTotalText"> &nbsp; </th>
  <th class="OraTotalText"> &nbsp; </th>
  <th class="OraTotalText"> &nbsp; </th>
  <th class="OraTotalText"> &nbsp; </th>
  <td <rw:headers id="HFAvgSALPerReport106" src="HBSAL106"/> class="OraTotalNumber">Average: <rw:field id="FAvgSALPerReport106" src="AvgSALPerReport" nullValue="&nbsp;"> F_AvgSALPerReport </rw:field></td>
  <td <rw:headers id="HFAvgCOMMPerReport106" src="HBCOMM106"/> class="OraTotalNumber">Average: <rw:field id="FAvgCOMMPerReport106" src="AvgCOMMPerReport" nullValue="&nbsp;"> F_AvgCOMMPerReport </rw:field></td>
 </tr>
</table>
</rw:dataArea> <!-- id="MG1GRPFR106" -->
<!-- End of Data Area Generated by Reports Developer -->
 
      </DIV>
    </TD>
  </TR>
</TABLE>
 
<P>
  <BR>
</P>
 
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
  <TBODY>
  <TR>
    <TD bgColor="#000000" colSpan=2><IMG alt="" border=0 height=1 src="images/stretch.gif" width=1></TD>
  </TR>
  <TR>
    <TD bgColor="#ff0000" colSpan=2 class="OraColumnHeader"><IMG alt="" border=0 height=4 src="images/stretch.gif" width=1></TD>
  </TR>
  <TR>
    <TD bgColor="#000000" colSpan=2><IMG alt="" border=0 height=1 src="images/stretch.gif" width=1></TD>
  </TR>
  <TR>
    <TD bgColor="#ffffff">&nbsp;</TD>
    <TD align=right bgColor="#ffffff">&nbsp;</TD>
  </TR>
  </TBODY>
</TABLE>
 
</BODY>
 
</HTML>
 
<!--
</rw:report>
-->

Open in new window

untitled.bmp
0
Comment
Question by:prince2002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 24816441
You have to start OC4J component before this.
0
 
LVL 2

Author Comment

by:prince2002
ID: 24817578
thanks. It is working now.
 I have one more question...
I am trying to run the same in another system. when i run it i am getting the browser with default homepage  and an error message in the report saying that "ERROR: Failed to locate the browser. Try connecting again". Before running that report i also started OC4J component.
Can anyone help me to fix this issue?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24821022
From other system?
You have to install either Oracle Application server with Business Intellegence component
or stand alone Forme/Reports server. I made many reports and had no problems.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24923908
Good luck!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question