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?

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.

Muhammad Khan

ASKER

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

Muhammad Khan

ASKER

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial