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 :
When I click on excel report button on the parameter form, the excel runs behind the form instead of in running in fron of it thereby making it partially invinsible. I am having to minimise the form to have a clear view. This is not the case with Forms 10g. Is there an extra code on the OLE2 to send the form to the background so that the excel output can take over the screen.
how to display data in tabular format but the printing direction is down/cross? I managed to change set printing direction but the column header is not showing on the cross section.
I expect:
Header1 Header 2 Header1 Header2 John India Max Singapore
But it displays without header name on the next part.
Header1 Header 2 John India Max Singapore
And also is that possible for matrix query to be printed in down/cross direction like above?
By setting the parameters in set_report_object_property parameters we can disable the printing option in 11g. Do we have some kind of option , to do the same in 10g.
I just want to ask that can we code number of pages to be printed before printing the report?
Like if we use report builder software of oracle to print a report, this will ask that how many pages you want to print and no of copies you want to make for this report as normally asked with other software before printing.
Actually, I am stuck with a complex query report where every single page has different query to execute. The problem with my report is that when ever user prints the report, the last page comes empty with the page header, no data in it.
What I want is to code, if possible, to print the report avoiding the last page to print. So that every time I can able to control printing pages. For example if report has 10 pages and definitely has data on 9 pages then it can only print up to 9 pages rather than going to print 10 pages.
Can viewing and direct printing the report become same? I always find some differences not in the data but the layout of the report. the layout of report that is viewed on the monitor through internet explorer is slightly displaced and small fonts compared with the report printed directly to the printer without viewing it on the screen.
I am trying to create a report, but for the second page its trying to print the text from the middle of the page, i.e its cutting half line, suppose if the line has description 'HELLO WORLD 123456' I see only 123456, the whole report is cutting the first 15 characters for the second page?
so i will give 10 invoices with dates in the above parameters to generate the report, actually the report prints in a pre-printed sheet, well it prints the first page correctly but the second page and continuous pages not printing in the exact pre-printed area. example see below;
(Page2) 506176 28/11/2011 (Preprinted text)INVOICE NO : INVOICE DATE:
how to give spaces between pages actually every pages it should print 3 to 4 inches gap between the first page but it prints just one inch above the preprinted area. how to make it print without gaps. Additional Information: Preprinted sheet Height 17 inches.
Paper Layout Width 8.5 Height 12
Character Mode
Report Width 80 Report Height 72
for header section, main and trailer sections above readings only given.
I want to print two record of emp table in same line number in tabular format report.
For example if i have emp table and I want to print empno,ename,sal columm only,In tabular format report, Two record should print per line. so If emp table have 14 record report should be printed on 7 rows.
so the output in print preview should be like this
EMPNO ENAME SAL EMPNO ENAME SAL ------ ---------- ---------------------------------------------- 7369 SMITH 800 7499 ALLEN 1600 7521 WARD 1250 7566 JONES 2975 7654 MARTIN 1250 7698 BLAKE 2850 . . . .
1) I am able to view the oracle report in PDF format in my Web Application, but when I tried to print this PDF on Line matrix printer, the characters are not printing rightly.
2) Can I take report output as a text file and and print it through DOS mode printing.
I have a requirement while A4 printing..When printing each time user have to select file -> page setup -> size(A4)..THEN printing format become A4 Size. How to achieve this one without user have to go on setting.
when I am trying to send report for prints then I received this error.
" REP-57054: In-Process Job terminated: The report generated successfully but distribution to destination failed. REP-50159:The report generated Successfully but distribution to destination failed. REP-50151: Destination ID Currency failed with error An error occured while sending the file to the printer :HPofficejetpro7700Series- Cannot run program "COrcaleMiddlewareasinst_5Config eportsin wlpr":
create process error=2, The system cannot fine the file specified."
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.
I am working on modifying various existing reports that other developers have created in the past. I noticed that on some of the layouts I am able to move frames and other objects by very small increments.
Yet in other reports if I try to move something just a tiny but up or down for example, it moves it by a very large increment. Is there some way, or some setting I need to set, in order to be able to move objects by smaller increments?
I am using OLE2 to update an excel spreadsheet from Oracle Forms 6i. If the excel spreadsheet is already open, the code runs through fine, and even asks if you want to replace the file when running the lines: OLE2.INVOKE(worksheet, 'Save');
OLE2.INVOKE(workbook, 'Save');
However, the file never gets updated. There is no error that appears. I would like to have the program check if the file is open before running the program;
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
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 ,
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.
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.
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
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".
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 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?
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.