Reports & Discoverer :: Character In Excel

Apr 6, 2011

i create report containe employee bank account and i have to converted to excel using button in the report page table is like this

(empno number(8),
bank_acc char(23),
salary number(13,2))

it work fine but my problem is most of the account start with zero like (000000546789) in report its appear okey but when i converted to excel its appear like this(2.36098E+11)

im using procedure RPT2XLS

this is the code i used as format trigger in the field of bank_acc

RPT2XLS.put_cell(1, acc1 ,FontColor => 1, FontSize => 10);

View 8 Replies


ADVERTISEMENT

Reports & Discoverer :: Oracle Reports In Excel Format

Jan 14, 2010

The environment of my company consist of an ERP system developed using Oracle Forms 4.5 and Reports 2.5. Now, due to increase in business activities, there is a lot of requests from users for reports in Excel sheet.

Our company is planning for Oracle ERP Rel 12....and it is under process of analysis..due to which there is no chance of upgrade to latest Developer Suite.

As of now, to fulfill user requirements of Excel based reports...what do you think is best and permanent solution? Is there any plug-in or Business Process or Business Intelligence application llike ORACLE BI Spreadsheet plug-in..which meets our demand.

As of now provide users with options to run the report and generate output in HTML format, from there, they copy it to Excel..but this process is not at all user friendly and feasible.

View 1 Replies View Related

Reports & Discoverer :: Creating Excel (because Of CHR(44))?

Oct 6, 2010

I creating a report in excel format...But there is one problem which i shown in colour when excel created.... i dont know why this problem come..Here i m attched my .fmb file and excel sheet [When i run my form].....

My Code is :
When Excel Button pressed
PROCEDURE EXCEL_P IS
cursor c1 is
select distinct BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO,
BPT_VEN_NM Vendor_Name,
BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,

[code]...

View 26 Replies View Related

Reports & Discoverer :: Character Report In Oracle 10g Like 6i?

Apr 15, 2011

Can I make charatcer report in 10g web application like 6i

View 1 Replies View Related

Reports & Discoverer :: Export Data From RDF To Excel

May 28, 2009

I want to generate the excel output from a RDF.

If I am using the DESFORMAT=DELIMITED then I am getting unformated data and some time I am getting less data as per PDF output.

There are about 25 queries with interrelated way.

How can I get the output in excel from a RDF.

In Reports 6i Functionality was working while we were running reports because of reports were running in Previewer mode but in 10g reports output coming in PDF format.

View 8 Replies View Related

Reports & Discoverer :: How To Convert Report To MS Excel And PDF

Mar 16, 2011

how to convert report to ms excel and PDF. for example emp table report convert to ms excel and pdf.

View 1 Replies View Related

Reports & Discoverer :: Export To Excel Setting

Mar 17, 2011

I used to click the "export to excel" icon on the menu and it open the excel worksheet with the option for me to save in the specified directory and name. But after my computer have Java v24 updated, when I try to export to excel, it does not give the option to open the worksheet instead it saves the excel file to the C:/users/ directory and overwrite every time I export.

View 1 Replies View Related

Reports & Discoverer :: Report In Excel Format

Nov 16, 2010

i m using oracle 10 report when i convert this report into excelformat and open in excel file then setting of this report is not proper ...how i can set this report

View 4 Replies View Related

Reports & Discoverer :: Character Report Generation Too Slow?

Oct 11, 2010

Problem:

I am using :
Database : Oracle 8i
Application Server: Oracle AS 9i
Developer Suite : Oracle 6i(forms & reports)

I have created some character reports in oracle reports 6i.. when reports used run from my ERP(oracle 6i oriented) ... report usually took time to create on server. Sometimes my ERP used to hang up due to reports lock. And then we have to kill some processes to finally create charater reports in emergency basis.

What is the valid reason for locks on report(character file )creation.?

View 4 Replies View Related

Reports & Discoverer :: Output Exported To Excel Sheet

Apr 22, 2012

We are using reports 3.0 and I want the report output exported to a excel sheet.. I got package contains some procedures, they have the below line where my report writer throwing error

TYPE ExcelCells IS TABLE OF ExcelCell;

encountered the symbol ";" when expecting one of the following .[@% not null range index.I doubt whether Reports 3.0 support "TYPE".

View 4 Replies View Related

Reports & Discoverer :: Convert Report To Excel File

Sep 23, 2006

How can i convert reports to excel file,in DELIMITED Format ,the report headings also coming in rows .

View 25 Replies View Related

Reports & Discoverer :: Bitmap Is Not Exporting To Excel File

Jan 24, 2012

I have added a bitmap image in my workbook but when i am exporting it into excel or HTML ,only text part of the title is exporting into excel file . The bitmap is only visible in discoverer workbook ,after exporting to excel or HTML, it disappears,

i am using oracle 9i discoverer version 9.0.2.0.

View 1 Replies View Related

Reports & Discoverer :: Workbook - Export With Formatting To Excel

Aug 5, 2011

I have a workbook in Discoverer which is not formatted correctly when I export it to excel. I have to re-size the columns and also adjust the height of the rows to see the data clearly.

Is there a way I can export the report without having to make these changes all the time?

View 1 Replies View Related

Reports & Discoverer :: Export Report 2 Into Excel File?

Oct 15, 2013

I have a report which i export into excel file,now i want --> i export my report into excel file then it (excel file) should automatically saved to my c drive.

View 6 Replies View Related

Reports & Discoverer :: Unable To Generate To File XML In Character Mode

Feb 17, 2012

I have a Report which run in character mode format, well i cannot convert or Generate to File as a XML File.

XML Conversion Error:

REP-1401: 'cf_1formula': Fatal PL/SQL error occurred. ORA-01403: no data found

PDF Conversion Error:

REP-1920: Character mode runtime incompatible with DESFORMAT of PDF, HTML, HTMLCSS, or RTF

But, when i change Character Mode to Bitmap or Default i can able to Generate to File.

So i Like to know is it possible to Generate to File in Character Mode?

View 1 Replies View Related

Reports & Discoverer :: How To Attach Excel File As Last Page Of RDF Report

Aug 3, 2012

I have an .xls file which needs to be the last page of an rdf report. I would prefer to not type up the contents of the file and lay them out. Is there some way I can link this to the footer section or any other alternative?

View 2 Replies View Related

Reports & Discoverer :: Convert Oracle Report To Excel Format

Nov 10, 2012

i m using oracle 9i (9.2.0.8.0) & developer 2000..I am getting below mentioned error when i convert Oracle Report to excel format.

"Report Builder
REP-1401:'afterreport':Fatal PL/SQL
error occurred ORA-43356 : Message 43356
not found; product = RDBMS ; facility = ORA "

View 5 Replies View Related

Reports & Discoverer :: Printing Heading In Excel Using OLE2 Objects Only

Oct 8, 2011

I am using oracle developer suit(form 10g), Using OLE2 object to initialize excel, On "BEFORE REPORT TRIGGER" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error :

" Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA."

View 1 Replies View Related

Reports & Discoverer :: Report Is Bringing Duplicate Records In Excel

Mar 7, 2011

when i run report in PDF, RTF or HTML then correct numbers of records appear but when i run same report in excel then it bring extra records (duplicate).

View 1 Replies View Related

Reports & Discoverer :: How To Generate Matrix Report To Excel File

Aug 22, 2007

how to generate matrix report to excel file. i have done this . but the exact layout is not getting displayed in the excel file. I have attache the layout i ma trying to export to excel.

View 8 Replies View Related

Reports & Discoverer :: Generate Excel Report Output With Maximum No Of Rows?

Nov 24, 2011

I created an xml report of output type 'xsl'. When the report output is generated for more than 65,536 rows then the report out put is not opening. generate excel report output with maximum no of rows.

View 1 Replies View Related

Reports & Discoverer :: Unable To Open Report In Microsoft Office Excel Format

Jul 6, 2010

I m trying to open Report in Microsoft Office Excel format with below code.

declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin

Web.Show_Document([URL]......);

end;

when my report run I received one message window File download after that this below error window appear & data can't show in proper format.

View 2 Replies View Related

Reports & Discoverer :: Convert Exponential Number Into Pure While Writing On Excel Using Builder

May 16, 2013

How to convert exponential number into pure number while writing on excel using report builder.Excel only takes 15 digit as pure number and remaining number it converts into zero or you can say in exponential form.

View 4 Replies View Related

SQL & PL/SQL :: How To Update Character Set Of A Excel Sheet

Oct 23, 2013

I am extracting Russian characters from db through a procedure and generating one excel sheet. But unfortunately in extracted excel sheet, I have to change the character set manually to "UNICODE(UTF-8)" , otherwise I can't able to see Russian character. how to update this character set through pl/sql ?

View 14 Replies View Related

Reports & Discoverer :: How To Run Discoverer Reports In A Forms Menu

Jul 5, 2010

how to Run a Discoverer Reports in a Forms Menu.

View 2 Replies View Related

Reports & Discoverer :: Launching Discoverer Viewer From Forms Menu

Dec 6, 2011

Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?

View 2 Replies View Related

Reports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer

Mar 19, 2012

When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.

View 3 Replies View Related

Reports & Discoverer :: Discoverer Admin - How To Copy Folder From One Instance To Another

Nov 9, 2011

I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.

View 1 Replies View Related

Reports & Discoverer :: During Open Report The Discoverer Application Frozen?

Jun 23, 2010

When I try to manage the report the Discoverer application frozen.

View 5 Replies View Related

Reports & Discoverer :: Provide Download Link To Blob In Database On Oracle Reports?

Aug 8, 2013

My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.

So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.

For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.

However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?

how to create a download link on the Oracle Report that let's them download a file out of the database.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved