Home » Developer & Programmer » Reports & Discoverer » Reports migration 10 to 11g - style sheets formatting and pagination issues (11g )
Reports migration 10 to 11g - style sheets formatting and pagination issues [message #630731] Sun, 04 January 2015 08:51
udayab1
Messages: 1
Registered: January 2015
Location: United States
Junior Member
Reports migration 10 to 11g - style sheets formatting and pagination issues

ANY LEVEL OF GUIDANCE OR HELP IS REALLY APPRECIATED.

The issue I am facing seems to be related to this area of reports documentation link

https://docs.oracle.com/cd/E15523_01/bi.1111/b32122/orbr_concepts2008.htm#RSBDR450

Output Formats and Capabilities

Absolute path /location to JSP in the url for new environment 11g seems to be working, similar to the existing urls in oc4j 10g.

This new environment testing url with absolute path that display fine, but cannot use this url dynamic in clustered environment in the new deployment situation, as it points war location under tmp folder.

But when given relative path in the new environment the formatting and pagination is not working and the differences observed in case of style sheets from view source.

Please see the urls and view sources headers to understand the issues.

I am trying to look more into the Oracle reports 11g documentation to understand / analyze the issue.
The issue seems to be related to how the url request for jsp is handled by rwservlet in case of weblayout vs paperlayout , in case of relative path for jsp like web application and absolute path like paper layout by report builder
The following documentation link seems to be relevant

http://docs.oracle.com/cd/E23943_01/bi.1111/b32121/pbr_run003.htm#RSPUB23539

18.3.3 Deploying a JSP Report to the Web and to Paper
JSP reports with paper layouts are executed through the Oracle Reports engine.
JSP reports with Web layouts are executed through the Java EE container.

Existing url in oc4j 10g reports that works fine

http://oc4j10gserverhost:7778/ApplicationReports/rwservlet?dbconnection&report=/ora/orabin/midtier/101202/j2ee/application-report s/applications/application-reports/application-reports/jsp/sample-report.jsp&destype=cache&pagestream=yes&desformat=htmlc ss


New environment testing url that display fine, but cannot use this url dynamic in clustered environment in the new deployment situation, as points war location under tmp folder.

http://oracle11greportserverhost:9003/reports/rwservlet?dbconnection&report=/ora/mw_frmrpt/user_projects/domains/application_frmr pt/servers/WLS_REPORTS1/tmp/_WL_user/application-reports/b8b6j3/war/jsp/sample-report.jsp&destype=cache&pagestream=yes&de sformat=htmlcss

New environment : trying the relative path url : that getting Display issue with formatting and pagination

http://oracle11greportserverhost:9003/ApplicationReports/jsp/sample-report.jsp?dbconnection&destype=cache&pagestream=yes& desformat=htmlcss


The view source differences from browser indicate the differences in the way report html is generated and how the style sheet differed...

Trying to check the oracle reports documentation to see how and where from the css stile sheet is picked up and html is generated.


view source for properly displayed for ...mainly differences in header parts and when you see the view source below...
11g absolute path ( looks like by report engine ) - in the first case i see a dynamic html generated with dynamic css generated ..
11g realtive path( looks like nby j2ee container like web app) in the second case with issues, I do not know where from the style sheet rwsp.css is picked up.

http://oracle11greportserverhost:9003/reports/rwservlet?dbconnection&report=/ora/mw_frmrpt/user_projects/domains/application_frmr pt/servers/WLS_REPORTS1/tmp/_WL_user/application-reports/b8b6j3/war/jsp/sample-report.jsp&destype=cache&pagestream=yes&de sformat=htmlcss


<style type="text/css">div{position:absolute;} </style>
<link rel="stylesheet" type="text/css" href="qkXsnSo6.css">



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html dir="LTR">
<head>
<base href=" http://oracle11greportserverhost:9003/reports/rwservlet/getfile/HW-YX+JkC1PhFv9Uw6XDyQzWLh3wtfbwgRvm9KB1Y4hysMe5MqqYEN6TFmOVkqML8co t/qkXsnSo6_1.htm">


<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<style type="text/css">
.t {font-family: helvetica; font-size: 12pt; font-weight: bold; text-align: left}
.l {font-family: helvetica; font-size: 10pt; font-weight: normal; text-align: left}
.hs {font-family: helvetica; font-size: 9pt; font-weight: bold; text-align: center}
.csc {font-family: helvetica; font-size: 9pt; font-weight: normal; text-align: center}
.csl {font-family: helvetica; font-size: 9pt; font-weight: normal; text-align: left}
.csr {font-family: helvetica; font-size: 9pt; font-weight: normal; text-align: right}
.csct {font-family: helvetica; font-size: 9pt; font-weight: bold; text-align: center}
.cslt {font-family: helvetica; font-size: 9pt; font-weight: bold; text-align: left}
.csrt {font-family: helvetica; font-size: 9pt; font-weight: bold; text-align: right}
.h {font-family: helvetica; font-size: 10pt; font-weight: bold; text-align: center}
.th {font-family: helvetica; font-size: 8pt; font-weight: bold; text-align: center}
.cc {font-family: helvetica; font-size: 8pt; font-weight: normal; text-align: center}
.cl {font-family: helvetica; font-size: 8pt; font-weight: normal; text-align: left}
.cr {font-family: helvetica; font-size: 8pt; font-weight: normal; text-align: right}
</style>
<title></title>
<style type="text/css">div{position:absolute;} </style>
<link rel="stylesheet" type="text/css" href="qkXsnSo6.css">
</head>
<body bgcolor="#ffffff">
<!-- Created by Oracle Reports 08:26 Wed Dec 24 08:26:07 AM, 2014 -->





view source for the one that has display issues with formatting style sheet and pagination

<link rel="StyleSheet" type="text/css" href="css/rwsp.css">


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<HTML>

<HEAD>
<TITLE>Data Load Request Summary Report</TITLE>

<link rel="StyleSheet" type="text/css" href="css/rwsp.css">


<META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</HEAD>

<BODY bgColor="#ffffff" link="#000000" vLink="#000000">
<br>
Data Load Request Summary Report
<br>

<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<TR>
<TD width="70%">
<DIV align="left">
<!-- Data Area Generated by Reports Developer -->




ANY LEVEL OF GUIDANCE OR HELP IS REALLY APPRECIATED.

Thank you Very much











[Updated on: Sun, 04 January 2015 09:09]

Report message to a moderator

Previous Topic: Get Error Number and Error Message printed to text file raised from oracle reports
Next Topic: Dynamically set max number of records per page
Goto Forum:
  


Current Time: Sun Apr 05 05:10:17 CDT 2020