Oracle Report vs JSP efficiency and Excel XML in Web Source Questions

Advertisement

I have used Oracle Reports in the past 6i, but haven't used them in about 4 years. We are now using 9.0.4 reports and I am trying to generate Excel XML from an Oracle report by manipulating the web source of the report. Basically copying and pasting the Excel XML into the web source of the Oracle Report instead of html as suggested by this Metalink Doc ID 240819.1. I do have a JSP working example that generates Excel XML created in JDeveloper and successfully spawns off a very nice looking Excel spreadsheet.
However, a statement was made here by our app sever guy that an Oracle Report is more efficient at getting data from the database than a JSP. The app sever section does not want anyone using JSPs to generate a report of any kind. I guess small web pages are OK since our java guys use them all the time. This rule for a Reports only environment seems a little restrictive to me. Is there any truth to the statement that Oracle Reports bulk collects data in one chunk as opposed to a JSP making multiple trips to the database from the middle tier?
Secondly, if an Oracle Report is more efficient in the way that it collects large record sets from the db, and if I save an Oracle Report as a JSP not an rdf, and use the reports_tld.jar with the rw tags instead of the typical jsp jstl tags, will I still get the same improvement from using an Oracle report? I guess the improvement is in the library used correct?
Thirdly, although not part of this forum, I also am assuming that if we have single sign on that when I call a JSP from an Oracle Form I will not have to log in again correct?
Thanks...
Message was edited by:
Mark Reichman

Advertisement

It could be the configuration issue. Reconfigure the engine.

October 11, 2015

Oracle Report vs JSP efficiency and Excel XML in Web Source Questions

I have used Oracle Reports in the past 6i, but haven't used them in about 4 years. We are now using 9.0.4 reports and I am trying to generate Excel XML from an Oracle report by manipulating the web source of the report. Basically copying and pasting

Publishing the report output to PDF and Excel

Hi, Is there any way to get the Report title, Report run date, Page numbers when we export the report output to Excel or PDF.Hi I am assuming you are working in 2004s <u><b>Exporting to PDF</b></u> For page numbering, add the follo

Viewing and purchasing on Desktop / Web Viewer Question.

I understand that if you share free content via your iOS app it can be viewed in a browser (with some features missing like swiping of images .) My question is this.... I have a Professional account... Can a person purchase the magazine and view the

Oracle Reports to J2EE

I want to migrate oralce reports to J2EE. Please suggest some tools available for the same.Hi, Reports9i can be saved in JSP format, not 2.5 or 6i. If by "migrating to J2EE" you only mean being able to call reports over the web, you can still do

Oracle Reports in PDF output

Hi everyone , We are using Oracle 11g. I have a custom Oracle report in PDF output. In some cases the value is changed. For example, when i run a query in toad i get a value 0.13, then I run my report, check the XML output - the value is still 0.13..

Moan about Reports ability to output to Excel

Hi there This is more of a general moan on this topic, but am I the only person who thinks that Oracle Reports' ability to output to excel should be WAY better than it is at the moment? I've just looked at the 9i demo, showing how to get report outpu

How to generate Excel files in Oracle Reports

Hi, I've already built a JSP using oracle reports and Deploy on the report service. I also add a button to the left of the JSP.The next thing I want to do is:when user click on the button, the system will prompt a excel file contains the same content

Why Reports format behaves different in Excel and browser(if desformat=html or pdf)?

1-Why Reports format behaves different in Excel and browser(if desformat=html or pdf)? 2-I made three queries Q1,Q2 & Q3 and linked them with proper field links but suppose Q3 returns no records for some Q1&Q2 records & when the report runs fo

How to get an effective EXCEL Spreadsheet as output for Oracle report 10g

Hi All, I am a newbie in Oracle reporting. I am using 10g. I have an oracle report whose output format is PDF from the user interface. User asked for Spreadsheet output. I changed the JAVA CODE "desformat" = Spreadsheet and got the report in Exc

XML and Excel

has anyone created any PLSQL using the XMLAGG and XMLELEMENT to create XML file output that can be read natively by MS Excel? I'd like to have/make something relatively simple that would have an API like this: make_me_excel( p_query =>    'select a,b

Oracle reports to XML problem

Hi All, I created raport in RDF and also created RTF file. Concurent request format is XML. Few weeks ago there was not any problem with this raport, but now it ends with WORNING (yellow collor). The error is: XMLParseException: Expected name instead

Error deploying oracle report JSPs in Jdeveloper.

Hi, I am trying to deploy and run a report created using oracle Report tool(comes with oracle 10g developer suite). I did the below steps. 1. I created a web layout report in oracle reports tool. 2. Open Jdeveloper (which comes in developer suite). 3

Converting a simple Oracle Report to XML Publisher report template

Hello, I have a simple Oracle Report 9i which displays data from four tables. It uses three different queries to get the data. How can I simply generate a template file(say RTF) or atleast an XML source from that report? I tried joining the queries (

Oracle reports output in excel format does not display the graphs

Oracle reports output in excel format does not display the graphs: "linked image cannot be displayed". The output file in PDF format the graph is supported.Do you have any header and footer on your template? If you have any header and footer the

Exception while opening a JSP file created using oracle report builder

I have created a JSP page which contains embedded Oracle reports build using Oracle Report Builder. I have deployed the JSP created above to the Oracle Application Server but when i try to open the JSP file it gives the following error: 500 Internal

Oracle Reports has comma as decimal separator in XML output

In XML, numbers should be canonical, otherwise BI Publisher errors with java.lang.NumberFormatException. (This regards the e-business suite, by the way.) We have trouble with our invoice report, a modified RAXINV, that suddenly makes XML files with c

Gettting error while trying to upload an xml in oracle report builder11g

REP-0069: An internal error occured. JDBCPDS-62008 : java.lang.NullPointerException This is the error m getting while trying to upload an xml with the option Open an existing report in Oracle Forms and Reports 11g An xml to be uploaded is as follows

Run XML Publisher Report  via URL (like Oracle Reports)

Hi All, Is it possible to run xml-publisher report via URL? In Oracle Reports works this fine: http://test:7777/reports/rwservlet?server=test_bihome1&report=test1.rdf&userid=test/[email protected]&desformat=pdf&destype=cache We need this for public

Oracle reports 11g excel

Hi, is there a way to export your rdf to excel???Hello, You can run a report and get the output on Excel by using desformat=spreadsheet or desformat=enhancespreadsheet. Please take a look on these metalink notes: Note 333080.1 Title: SPREADSHEET - De

Oracle report 10g publsinng on web and Oracle Portal

I am converting a report that was using oracle OAS9i, we pass to URL(rdf file) userid/password and worked fine. We were not using Portal, even though it is installed by OAS. Now seems we have to use Oracle Portal to publish the same report. Is that r