prince2002
asked on
Error while running web layout report with Oracle Reports Builder in Oracle Developer Suite 10g
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..
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> </TD>
</TR>
</TBODY>
</TABLE>
<TABLE bgColor="#ff0000" border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD bgColor="#ff0000" class="OraColumnHeader"> </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=" "> F_empno </rw:field></td>
<td <rw:headers id="HFENAME106" src="HBENAME106"/> class="OraCellText"><rw:field id="FENAME106" src="ENAME" nullValue=" "> F_ENAME </rw:field></td>
<td <rw:headers id="HFENAME1106" src="HBENAME1106"/> class="OraCellText"><rw:field id="FENAME1106" src="ENAME1" nullValue=" "> F_ENAME1 </rw:field></td>
<td <rw:headers id="HFDEPTNO106" src="HBDEPTNO106"/> class="OraCellNumber"><rw:field id="FDEPTNO106" src="DEPTNO" nullValue=" "> F_DEPTNO </rw:field></td>
<td <rw:headers id="HFSAL106" src="HBSAL106"/> class="OraCellNumber"><rw:field id="FSAL106" src="SAL" nullValue=" "> F_SAL </rw:field></td>
<td <rw:headers id="HFCOMM106" src="HBCOMM106"/> class="OraCellNumber"><rw:field id="FCOMM106" src="COMM" nullValue=" "> F_COMM </rw:field></td>
</tr>
</rw:foreach>
</tbody>
<!-- Report Level Summary -->
<tr>
<th class="OraTotalText"> </th>
<th class="OraTotalText"> </th>
<th class="OraTotalText"> </th>
<th class="OraTotalText"> </th>
<td <rw:headers id="HFSumSALPerReport106" src="HBSAL106"/> class="OraTotalNumber">Total: <rw:field id="FSumSALPerReport106" src="SumSALPerReport" nullValue=" "> F_SumSALPerReport </rw:field></td>
<td <rw:headers id="HFSumCOMMPerReport106" src="HBCOMM106"/> class="OraTotalNumber">Total: <rw:field id="FSumCOMMPerReport106" src="SumCOMMPerReport" nullValue=" "> F_SumCOMMPerReport </rw:field></td>
</tr>
<tr>
<th class="OraTotalText"> </th>
<th class="OraTotalText"> </th>
<th class="OraTotalText"> </th>
<th class="OraTotalText"> </th>
<td <rw:headers id="HFAvgSALPerReport106" src="HBSAL106"/> class="OraTotalNumber">Average: <rw:field id="FAvgSALPerReport106" src="AvgSALPerReport" nullValue=" "> F_AvgSALPerReport </rw:field></td>
<td <rw:headers id="HFAvgCOMMPerReport106" src="HBCOMM106"/> class="OraTotalNumber">Average: <rw:field id="FAvgCOMMPerReport106" src="AvgCOMMPerReport" nullValue=" "> 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"> </TD>
<TD align=right bgColor="#ffffff"> </TD>
</TR>
</TBODY>
</TABLE>
</BODY>
</HTML>
<!--
</rw:report>
-->
untitled.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
Good luck!
ASKER
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?