Solved

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

Posted on 2009-07-08
4
3,210 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 500 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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup
Suggested Courses

635 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