I have developed few reports for ebusiness suite in various sizes as 8.5 * 8.5, 8.5*11 and 8.5 * 12.My OS is Linux Red Hat 8.5 and the printer is Epson LQ 300. All the reports are TEXT and I am facing a printing problem to print in various sizes as we need to print all these reports by using a single printer.I created different print queues with the default paper sizes as above mentioned to print the reports, but the printer never considers any specified paper size and always printing for the default A4 size of 8.5 * 11.
I'm developing now in 11g and i have some reports that i want to send directly to the printer. I been having some troubles and as i searched the web, i saw that for 9i and 10g, this was not possible without using orarrp. But i can't find any info about this for 11g. Is this true that i can only let user print direct using this tool? Plus, is this tool available for linux x64? Can i add the printer to the server and would it work now?
I am building an application to edit database data through interactive reports. I would like to add a button to open a pdf file of the report, where the user can save or print it. I tried going to Shared Components>Report Queries and then create. I went through the steps but when I get to the end where it says "Test Report" I get this error:
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified
What can i do to fix this, or is there an easier way to do this?
I am using APEX 4.0.2.00.09
This app will be distributed to other computers if that makes any difference.
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?
I am using "Function Returning SQL Query" (as query is dynamic) to draw the bar chart (flash).
I am facing some issues while trying creating a BI report for this chart.
Issue is : In Shared Components -> Report Queries : Its only expecting an SQL Query.
Do we have any ways to define a "Function Returning SQL Query" over here ? Note that, If using a static SQL both charts / BI reports are working fine with out any issues.
After validating the SQL statemnet during creating a Custom folder in OracleBi Admin following Error displays. While the same query execute in toad successfully.
The Custom SQL entered is not a valid SQL statement - ORA-01031:Insufficeint Privileges
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?
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 :
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."
I have one problem related to run Report 6i on Linux Environment.I have created new report with New Rupees Symbol(Rupee foradian) for Windows Operating System it is working properly appears new rupees symbol sign properly.
But i compile same report in linux environment and after that run through browser new rupees symbol not show properly instead of rupees symbol `(entitled sign)appears on my report.
I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.
I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.
I have a dot matrix printer (Epson LQ-2180, which is a tractor feed printer). While printing a report which contains cheque information. Now while displaying the report it display in correct size but while I print the report by default it takes printer page size and print in that paper size. I want to print the report in cheque size with continuous sheet with more than 900 cheque which defined in report property.
I want that the printer should print exact page length and width what i defined in report.
1. What is the maximum page size (width X height) of the report? 2. How many characters (maximum) in one line (horizontal) supported by report 10g? 3.How many row per page (vertical) supported by report 10g?
I am using the Report 6i. By using the same tool i created a report. It printing portion is working correctly (that is printing only Half of the page but the next page is move to after scrolled to balance of A4 size). But i want to print with in A4 two pages.
I created using the following property setting....
Layout model-main section-property
Section width 8.5 height 5.9
Character Mode Report width 80 Report Height 35
But it utilizing to print half page and balance is scrolled then new page is start(new A4 next paper).
I have this problem. I need to print in paper size of 14.875x11 or us std fan fold. But when I print, some part is not printed, like a size of 11x8.5. Questions:
1) Is there a way I can print in 14.875x11 without configuring the page setup to 14.875x11 and automatically print what ever i can see on my live pre viewer? 2) What should be the value of Report Width/Height if it affects the printing size?
I'm working on an RDF report. This report runs as a part of Payment Process in Oracle Payables. This report has the printer style as BACS. The layout has only main section. The body of the main section of the report has only one repeating frame and the body field inside the frame. The body field gives concatenated values from the select query. I have to modify the SQL query(where clause) of the report. After I change the query and save it, the report compiles sucessfully on report builder.
However after following payment process and submitting request, the report fails with error:
