Oracle Reports SPREADSHEET option QUERY


Has anyone used the SPREADSHEET option for exporting.
Is there any mechanism or setting that we may have to set, so that I dont switch off wordwrap for each cell?
Is there any mechanism or setting that we may have to set, so that I can see the gridlines of the excel.
Pls comment as this is urgent...
Thanks a lot


You keep coming back to this without even bothering to answer previous suggestions:
Oracle reports question

November 30, -0001

Oracle Reports SPREADSHEET option QUERY

Has anyone used the SPREADSHEET option for exporting. Is there any mechanism or setting that we may have to set, so that I dont switch off wordwrap for each cell? Is there any mechanism or setting that we may have to set, so that I can see the gridli

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

Running Web Layout Of JDBC Query in Oracle Report Builder 11g.

javax.servlet.jsp.JspException: REP-4100: An attempt to execute data source failed. JDBCPDS-62008:A SQL error occurred: {0}. S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt javax.servlet.jsp.JspException: RE

ORACLE reports Build 10g - Data Model - query - If statement in Alias ?

I have the following select statement. It has the alias Survivors, Deaths and "All With the ORACLE reports Build 10g - Data Model - I have the following query statement. I require the alias to change. Can the following be done. Cases". Is it pos

Sum function do not work in oracle reports enhanced spreadsheet format

we are using oracle reports in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel

Create word document based on query in oracle reports

Database version Oracle9i Enterprise Edition Release - 64bit Production PL/SQL Release - Production CORE Production TNS for HPUX: Version - Production NLSRTL Version - Production CREATE TABLE TAB1 DEP

Oracle reports general query

Can DDL statements be run from Oracle reports If yes how? Thanks, sagarhi; Please check below link: Regard HeliosRead other 2 answers

Oracle Report Server wierd problem

Hi All, I am facing very wierd problem with oracle report server. I am using Oracle Report Server 10g R1. The problem I am facing is as under: There is custom parameter form where user enters report filter criteria and press a button to create the re

Changing Database Oracle Reports Connection.

Hi Fellows. I would like to know if it is possible to Change Oracle Reports Connection (Ver2.5) after the end user fill in the Parameter Form. I have about 21 agencies with a Database in each one and the end user have to choose the agency what he wan

I am unable to get order by column name in oracle report parameter form


Changing Oracle Report Output Format at runtime

Dear All, I've custom Oracle Report in Oracle Apps., and would like to give the users an option to select the output format (XML, TEXT, PDF, etc.) whilst submitting the request. As a SYSADMIN, we can modify the Output Format value of the concurrent p

Oracle Report reading only upto 1600 lines

Hi all, Just would like to post an issue regarding oracle report. My version is DS 10g n i have a code which is approx 2000 lines, the issue is that my query executes till near about the 1600 but the rest is omitted.plz throw some light in this. Than

Unable to start Oracle Reports Server for 10g version

Attention Oracle Reports Team or anyone else: I am unable to start the Oracle Reports Server for 10g version of the Application Server. I have included the trace files see below. I marked the text in bold that might indicate the issues. An

Oracle Reports - Distributing Multiple Reports in a Management Report

Hi, I am new to Oracle Reports and would sincerely appreciate some guidance. Requirement. I plan on using Oracle Reports to write multiple reports containing Text, Graphs, Crosstabs, Tables etc. There are 3 developers and each will be developing a nu

Oracle Report Server Not Accessible

Hi Folks, I'm facing a series of issues with Oracle reports server 11g. I'l list the issues one by one. 1. I'm not able to start the weblogic server from the domain which i've created for Reports. It gives me authentication error. I've tried clearing

Pass a ViewObject as a data parameter into Oracle Reports

Can I pass a ViewObject as a data parameter in an Oracle Reports jsp Report?you can use impliment this script to your query get data from file function AfterPForm return boolean is infile text_io.file_type; linebuf varchar2(3000) := ''; filename varc

Lexical Parameter in Oracle Reports . . .

Hi all, I am trying to pass a value to a query in oracle reports . . . the use of the parameter is to add 2 additional columns to an existing query, if a bind parameter is set to 'Yes' else the parameter carries a value NULL; Here is the code I have

Using CLOBs in oracle Report Builder

I want to select all the data in a CLOB column using SQL Navigator by just doing select entry_note from chartentries; just as you say in your example by it just gives me back a result of (ORACLOB). If I do select to_char(entry_note) from chartentries

2-D Barcodes in Oracle Reports

Hi All, I am trying to implement 2-D Barcodes on a text field in Oracle Reports 10G. Can someone please let me know how this can be acieved ? Thanks FmHi, unfortunately that option is still not supported. There is an enhancement request filed for tha

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 (