I am using HP laserjet 1020 plus printer with windows xp sp2 and reports builder 6.0.8.8.3. Problem is that printer does not print the reports generated by d2k i suppose printer command is not sent to printer. My another printer HP laserjet 1160 can print the same reports without any trouble.
View 1 RepliesHow to print report if printer use IP ( 172.17.10.252 , 172.16.10.252)
View 1 Replies View RelatedI have developed a bitmap report on report 6i, But I am not able to print report on printer (Thermal Printer Model PRP-085III, A baylan POS printer).
I tried to convert the same report to Character mode and it print fine.
why it is not printing or what I need to set ?
i want to use Graphic builder for make a chart in report builder. how can i use them for create a chart report? i need to see some samples for create my project. put a sample of .OGD and .rdf
View 6 Replies View Related1) 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 could not connect the reports builder to the database. Im trying to connect it to the XE database. I checked the tns names and the hosts. Everything seems to be fine. But still when i try to connect the report it throws an error "ORA 12541- tns no listner"..
View 11 Replies View RelatedI want to print a report to the printer directly. The main issue is that I don't want the user to save the report to prevent reprint of legal Order. Below is my code to produce 'PDF' format.
PROCEDURE
run_report_proc (rep_id report_master.REPORT_ID%type,pl_id ParamList ) IS
repid REPORT_OBJECT;
rep_name report_master.REPORT_NAME%type;
v_rep varchar2(1000);
rep_status varchar2(20);
rep_acc char(1);
[code]....
I am using Java print API (javax.print package) to send a bunch of documents for printing. Below is the code section that I am using to print documents through java program. When the document is sent for printing, I see the Job name is created properly in the print spooling queue on windows machine. But, when i go to the actual printer, the job name is different on the printer than what i saw in spooling. Since I am printing 100s of documents in batch, it gets very difficult to identify which document did not print, in case of issues. I also used the java.awt.print package . The java.awt. print. PrinterJob has a method setJobName(String). When i used this package, I got the name appear properly in both places. But I wish to use javax.print with the document name appear on printer queue.
public void printDocument(File pDoc, PrintService pService, DocFlavor pFlavor)
throws Exception { logMessage(true, "Printing Doc::" + pDoc.getAbsolutePath());
FileInputStream is = new FileInputStream(pDoc);
// Create the print job DocPrintJob job = pService.createPrintJob();
//Set print request attributes with file name as job
[code].....
I'm trying to have RB use the following query:
WITH MY_DATASET
AS (SELECT /*+ materialize */
DISTINCT
N.NAME_ID NID,
NVL (TO_CHAR (RN.CONFIRMATION_NO), 'ACCOMPAGNATORE') CONF,
RN.RESV_NAME_ID,
MEV.TAX1_NO PARTITA_IVA,
[code]....
But although perfectly working in SQLDeveloper, RB returns an ORA-942 table does not exist error, pointing at MY_DATASET as the offending name.
I need to produce Excel spreadsheet from report builder.currently I am getting a format like,
ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;
This format when opened in Excel does not group in separate columns resulting in all getting mixed up.I am looking a format like,
ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,
This opens up clearly on excel. items like Product,Count are shown on separate columns along with the value.I am still looking into delimited formatting.
My report builder crashes if I try to insert a graph from tool pallete.
View 5 Replies View RelatedIn Sales Order Form there is a print receipt button. In current situation On Clicking the 'Print Receipt Button' it submits a XML Publisher report(PDF output) to the concurrent manager. Currently to print that report i need to go view--> requests--> view output and then print. According to my new Requirement i need to print that report directly to local printer on one simple Print receipt button click in form.
I am trying to call the printers on server using custom.pll. The report is running successfully but it is not printing output to the local printer. I need to print the report to the local printers based on responsibility. Local printers are available on apps server.
Is it possible to print the document using custom.pll? Is there any other alternative to print the report on simple button click in form.
I searched many forums but i found customizations on form level. I am trying to customize the form using custom.pll. I found many examples like URL..... but i don't think i can use these practices in custom.pll. ADD_PARAMETER & RUN_PRODUCT dont work in custom.pll. I need to complete this requirement immediately.
Environment: Apps 11.5.10.2, Forms 6i
Here is the code that i am using in my custom.pll.
if (v_form_name = 'OEXOETEL' --and v_block_name = 'LINES_SUMMARY'
and name_in('parameter.ACTIONS') = 'PAYMENT_RECEIPT' )THEN
l_organization_id := Name_In('PARAMETER.OE_ORGANIZATION_ID');
l_order_header_id := Name_In('ORDER.header_id');
select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
xml_layout := FND_REQUEST.ADD_LAYOUT('XXAFP','XXAFPOEXPMTRCRTF','en','US','PDF');
[code]....
I am creating report a using emp table .There are 14 rows in emp table , i want to print output into two pages . If i set FILTER TYPE Property to 5 ,it only shows 5 records .
View 2 Replies View Relatedi am creating a report using a function in the select query..suppose this is my function that i created in the program unit of the report
FUNCTION is_numeric_rep (p_strval in varchar2) RETURN
NUMBER
IS
l_numval NUMBER;
BEGIN
l_numval := TO_NUMBER(p_strval);
RETURN 1;
EXCEPTION
WHEN OTHERS THEN
RETURN 0;
END is_numeric_rep;
and also suppose this is the query of the report
Select
is_numeric_rep('343aa43')
From dual
when pressing ok on the query statment in the report it give me this error: ORA-00904 "is_numeric_rep":invalid identifier although when i create this function as a stored function in the database schema and use it in the report it works fine with no problems.
I am facing an issue here at my workplace, there is a report developed in report builder , the user wants to see the digits in arabic.
View 4 Replies View RelatedI've created report to generate letters,my query contains records more than 1000 while generating report it shows report progress
"Formatting Page 1000" after that report builder gets closed without any error message,I've tried for 10 records it is working fine,
I have a report based on one table with three columns , one column will be updated upon user intervention that if approves the status flag of that column will be 3 and if he amends it will be 1 , by default it will be null.I want to display digital signature or image if the status is approved.I want to store the image/digital signature in Database.Do i need to create a table with BLOB column and store.
create table ot_rq_head ( r_date date, r_no number , r_status number );
insert into ot_rq_head values(sysdate,1,null);
i want to display such as ratio and degree in the reports 6i, how can i add them ?
View 2 Replies View RelatedMy report looks somewhat like below -
|---------------------------| Frame_M1
||-------------------------|| Repeating_Frame_R1
|| ||
|| Field_F1 ||
||-------------------------||
|---------------------------|
For M1, R1 and F1 I have set print object on All Pages and base printing on Enclosing Object. After running the report, output is only one page and consists of 7 rows. But as per the query it should have fetched 21 rows.
When I have changed print object on property to First Page, it output is 2 pages and consists of all 21 records.So, why print object on All Pages generating only one page while print object on First Page generating 2 pages?
searched here for Tick Sign in Reports & Discoverer section, but did not find. i am trying to work on Reports and have a requirement of Tick Sign should appear in report if the column value is 'Y' means yes.
i tried following SQL statement in SQL*Plus, but failed to find and Tick Sign.
declare
n number:=0;
c varchar2(1);
begin
for i in 1..255
loop
select chr(i)
into c
from dual;
dbms_output.put_line ('* '||lpad(to_char(i),3,' ')||' -> '||c);
end loop;
end;
How to print barcode in report 6i
View 5 Replies View RelatedI have designed a report (by oracle report 6) when i run it on the report preview when choosing print the print dialog box doesn't appear on other pc the dialog box appears.
I want the print dialog box to show.
I set the JOBPRINT parameter to yes which is the default value but didn't solve it.
In Oracle Report Builder 11g whenever i set destype to file report Builder Stops.
View 15 Replies View RelatedMy own created software is running since last 4 years but now when I am trying to run a report then I got a message "REP-0002 unable to retrieve a string from the report builder" and as a result my report don't run. Please note that some other reports are working properly, this problem is happens only with some of them reports.
View 3 Replies View RelatedHow to check in which port : OC4j instance is running ??
How to run the report using : OC4j instance and deploy into application server?
I have developed a tabular report in report builder 6i. Total columns in report 28 in all. Now its throwing following error.
REP-1213: Field 'F_orpahn_Code'references column 'orphan_code'at a frequence below its group
How to Print Customer Copy / Office Copy in rports 6i for example i want to print two copies of any report i want that on first copy of report shows CUSTOMER COPY and second copy of shows OFFICE COPY and report may be on multiple pages.
View 1 Replies View Relatedhow to print copyright symbol in rdf reports. I receive a ? when it gets printed.
View 3 Replies View RelatedInherited a report created in 6i (works fine) and learned it doesn't correctly display in 10g! (Example attached) Cell frames do not print when there's no info to display, leaving blank gaps in the report. Is this a bug or something in Reports 10g that's causing the problem?
View 7 Replies View RelatedI want to disable print option in oracle reports 10g while it is opening in browser.Internet explorer version is 6.
View 3 Replies View Related