Avatar of Muhammad Khan
Muhammad KhanFlag for Canada asked on

Suppressing Print Dialog in Oracle Reports 6i

hi everybody,

I want to print a label using Oracle Report 6i, i have setup print setting through report parameters and now i don't want this Print Dialog to appear when user hits enter at parameter form, the output should be sent to the printer directly.

Any ideas on how to suppress Print Dialog in Reports 6i?
Oracle Database

Avatar of undefined
Last Comment
Muhammad Khan

8/22/2022 - Mon
schwertner

Drop the parameter Form from the Data Model.
If you have no parameter form there will not be
a dialog.
If you have other parameters in the Parameter form
either set default value (From the Report Parameter for printing)
or drop the Print parametre from the parameter form.
ASKER
Muhammad Khan

User has to enter 1 important parameter so dropping parameter form is not an option.
schwertner

Then drop the Print parameter from the parameter form
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
Muhammad Khan

there is no such parameter in my parameter form

i have got this far now

I  have now used a form to call the report. and i am setting the following parameters , the problem is; when i set DESTYPE to PRINTER, printer prints a label but there is no data on the label.
if i change destype to SCREEN, it will show the data in previewer and i can use print button to print label correctly.
Can u tell me what i am missing/


Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'PRINTER');
Add_Parameter(pl_id, 'DESNAME', TEXT_PARAMETER, 'Zebra TLP2844');
schwertner

DESTYPE' and 'DESNAME' are system parameters of the report.
They can not be removed.
You can change them to

Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'SCREEN');
or
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'FILE');

If you open Reports Developer in the online Help you will find all
accepted values of these parameters.
ASKER CERTIFIED SOLUTION
Muhammad Khan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question