?
Solved

how to have the report printed from the user's selected printer

Posted on 2002-04-18
6
Medium Priority
?
1,382 Views
Last Modified: 2011-08-18
Hello oracle masters,

Question:  How do I get a report executed from a form and printed to the printer that the user chose?  I need the form to run the report, then ask the user which printer he wants the report to print (list of printers = installed printers in the current client pc).

Software Info:  I'm currently using ORACLE FORMS DEVELOPER 6i and Database 8i.

Sample Data:  In the Sampleform.fmb, there's a button with the following 'When-Button-Pushed' trigger:
repid := find_report_object('INVOICE');
v_parameter := 'paramform=no,INVNO='||:TABLE.invno;
set_report_object_property(repid,report_other,v_parameter);
v_rep=run_report_object(repid);

In the reports group of Sampleform.fmb, the INVOICE is set to the following:
Filename = print_invoice.rdf
Execution Mode = Runtime
Report Destination = Printer

The print_invoice.rdf has a user parameter INVNO and the query needs this parameter to run the form.

Any suggestions would really be appreciated....
zandy-
0
Comment
Question by:zandyl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 

Accepted Solution

by:
nlabbe5 earned 600 total points
ID: 6951962
Include the D2KWUTIL.PLL library to your form.

Add a button with a WHEN-BUTTON-PRESSED trigger:

DECLARE
 PrinterName        VARCHAR2(100);
 Port               VARCHAR2(100);
 RaiseExceptions  BOOLEAN ;
     
BEGIN

  Win_Api_Dialog.Select_Printer
    (PrinterName ,
     Port,
     RaiseExceptions );
 
END;



0
 

Author Comment

by:zandyl
ID: 6953659
how do i find these file?  i tried adding it into the attached libraries but its not in the list - even when i tried looking for it in the oracle home directories .

0
 

Expert Comment

by:nlabbe5
ID: 6954072
I found d2kwut60.dll in C:\ORANT\BIN directory.  In the documentation, they talk about D2KWUT32.DLL but I did not find it in my directories.

I just wrote D2KWUTIL.PLL and Oracle Forms found it automatically.  
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:zandyl
ID: 6954198
okay, i found it but now its giving me the following error:
'FRM-40734: Internal Error: PL/SQL error occured'

any suggestions....
zandy-
0
 

Author Comment

by:zandyl
ID: 6954300
could anyone suggest where i could download these 'demo oracle libraries' for developer 6i version?

zandy
0
 

Expert Comment

by:nlabbe5
ID: 6954767
What is your OS? Your Forms Developer version?

Anyway, I found this on http://metalink.oracle.com:

fact: Oracle Forms Developer 6.0.8.8.0
fact: Oracle Forms Developer 4.5
fact: MS Windows NT 4.0 (32-bit)
fact: SF40
fact: Attached the d2kwutil.pll package
symptom: Error from select_printer: FRM-40734
symptom: win_api_dialog.select_printer(v_printer,v_port,TRUE);
symptom: Frm-40734 Internal error PL/SQL error occured
cause: It is not the correct d2kutil.dll


fix:

1. Copy the latest d2kwutil from the following location:
ftp://oracle-ftp.oracle.
com/dev_tools/patchsets/dev2k/Win95NT/d2kwutil/
2. Extract over the existing files (all files in the self extract archive)
3. Copy the d2kwut60.dll in ORACLE_HOME\BIN directory.
See also <BUG:1293747>

0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question