Reports & Discoverer :: Can Viewing And Direct Printing Report Become Same

Jun 14, 2012

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.

View 2 Replies


ADVERTISEMENT

Reports & Discoverer :: Report Printing In 11g

Sep 25, 2012

I am facing problem while printing from the Oracle Report.. Web.show_document does not print the output of RDF file directly on the printer.

View 1 Replies View Related

Reports & Discoverer :: Report Not Printing Complete Line On Second Page

Oct 28, 2010

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?

View 1 Replies View Related

Reports & Discoverer :: Oracle 10g Report Printing On Line Matrix Printer?

Apr 15, 2011

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.

View 2 Replies View Related

Reports & Discoverer :: 11g Printing Error - Report Generated Successfully But Distribution To Destination Failed

Jul 10, 2010

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."

View 6 Replies View Related

Reports & Discoverer :: Handle Duplex Printing In XML?

Nov 11, 2010

how to handle Duplex Printing in XML? I have a Oracle XML report (rft and xsl) that needs to be duplex.

View 1 Replies View Related

Reports & Discoverer :: Down Cross Printing Direction?

Jul 10, 2013

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?

View 1 Replies View Related

Reports & Discoverer :: Getting Error While Printing User Name

Apr 6, 2011

following is my code written in formula column

function CF_1FORMULA0006 return Char is
v_user_id number;
u_name varchar2(100);
begin
fnd_profile.get('user_id',v_user_id);

select user_name into u_name from fnd_user
where user_id =v_user_id;
return u_name;
end;

getting no data found error.

View 2 Replies View Related

Forms :: Direct Printing On 10g - Errors When Distribute Output

Jul 20, 2012

I have a problem with direct printing on forms 10g, I try to explain all schema...Firstly, this is my code

repid := find_report_object('OPERATOR_BARKOD');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,RUNTIME);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_server_oracle');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,PRINTER);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'ipp://192.168.200.22/operatorbarcode');
v_rep := RUN_REPORT_OBJECT(repid);

The code works fine if i change the "report_desttype" to FILE or CACHE and give a local path "REPORT_DESNAME" like "/home/ oracle/ desktop/ barcode.pdf"

Secondly, My oracle application server is running on oracle linux 5.0

Thirdly, I defined network printer(model:XeroxPhaser3435) over ipp which path is "ipp://192.168.200.22" and name is "P3435" also default printer for oracle user and printer works i can get test page.

I wonder is printer path correct?("ipp://192.168.200.22/operatorbarcode"). I think the problem occurs in this step also is there any extra settings for oracle application server to use network printer...When I look at the reports server jobs it give an error "Executed successfully but there were some errors when distribute the output".

View 2 Replies View Related

Reports & Discoverer :: How To Disable Printing Option In Oracle 10g

Sep 17, 2012

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.

View 1 Replies View Related

Reports & Discoverer :: Control Pages Dynamically Before Printing?

May 23, 2011

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.

View 1 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 :: Continuous Pages Not Printing In Exact Pre-printed Area

Nov 29, 2011

I have a Invoice Report, i will give the parameters.

From_Inv_No:
To_Inv_No:
From_Inv_Date:
To_Inv_Date:

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.

View 3 Replies View Related

Reports & Discoverer :: Multiple Record Printing On Same Line Number In Oracle 10g?

Jun 28, 2013

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
.
.
.
.

View 1 Replies View Related

Reports & Discoverer :: When Printing Each Time User Have To Select File / Page Setup

Oct 21, 2011

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.

View 1 Replies View Related

Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report

Sep 20, 2012

How can i print a report name with full path at left bottom on report.

View 3 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report

Nov 29, 2011

I am trying to open report in parameter form in drill down report.

View 7 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report

Dec 19, 2011

I had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?

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 :: Anyway To Stop Report In Before-Report Trigger

Jul 24, 2011

Is there any way of stopping the report from executing in Before-Report Trigger.

Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.

how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.

View 2 Replies View Related

Reports & Discoverer :: How To Create Aging Report In Discoverer

May 28, 2010

[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?

Which tables should be refered for Ageing reports.

[Message #2] How to create an ageing report in discoverer?

Which tables should be refered for a Ageing reports.

Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.

View 1 Replies View Related

Reports & Discoverer :: How To Merge Multiple Reports In One Report In 6i

Aug 23, 2011

How to merge multiple reports in one report in reports 6i.

View 1 Replies View Related

Forms :: Report Without Viewing Send To Printer?

Jun 14, 2012

WHEN-BUTTON-PRESSED

declare
repid report_object;
v_rep varchar2(200);
CNT NUMBER:=1;
ATC VARCHAR2(30);

[code]...

My issue is i have 3 locations(Area) following report run only at in house where AS Located i want to run this report at every location.

View 1 Replies View Related

Reports & Discoverer :: Calling Report From Another Report

Aug 31, 2010

I created two reports separately.

1.pub.jsp
2.serc.jsp

what i need is i want to call the report serc.jsp from pub.jsp .

View 6 Replies View Related

Reports & Discoverer :: How To Call A Report From A Report

Aug 17, 2012

How to Call a Report from a Report?

Not from a form but a Report from a Report?

View 3 Replies View Related

Security :: Viewing Report Of Audit Trail From Dba_audit_trail

Apr 11, 2013

in my environmnet audit is working audit_trail=db,extended . i am also viewing report of audit trail from dba_audit_trail or aud$. But problem is that i have to generate report on which object of schema what audit is running .

or from which tables we can get information of following commands.

AUDIT ALL BY xx_test BY ACCESS;
AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY xx_test BY ACCESS;
AUDIT EXECUTE PROCEDURE BY xx_test BY ACCESS;

View 3 Replies View Related

Reports & Discoverer :: Unable To Run The Report In 10g

Dec 6, 2012

The code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.

I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)

View 3 Replies View Related

Reports & Discoverer :: How To Run Report In Menu

Oct 19, 2011

How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?

View 5 Replies View Related

Reports & Discoverer :: Report In Arabic PDF?

Oct 6, 2010

We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.

we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"

[code]...

View 3 Replies View Related

Reports & Discoverer :: How To Create Report

Apr 30, 2013

I want to create report using this query, is there any option?

declare
cursor c2 is
select epi_id, epi_code, epi_name

[Code].....

View 4 Replies View Related







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