Hello everyone,
I am printing reports using PL/SQL without opening Print Dialog form using the code described in the following topic:
Depending on the case, I need to open the Print Dialog. Does anyone know how can I call the Print Dialog from PL/SQL code?
Regards
Hi
As far as I’m aware it’s not possible to do with PLSQL. You need to enable and print dialog from client end pass result key to the print dialog from client end.
Thanks & Regards,
Asanka.
Asanka is correct. Print dialog is a client function, not a database function, so it cannot be called with plsql.
As confirmed already, this isn’t possible as the Print Dialog is a client-side UI component and the PLSQL layer exists in server side.
If you want o somehow allow the users to provide some data and then execute your PLSQL logic to run the report, a custom logical unit, a custom page (with printing parameters like Rep_ID, Layout ID, etc. ) and a custom menu would work. I’m sure that’s an unnecessary chaos but something that’d work if this is a mandatory requirement to skip the standard printing UI flow.
As an addition to this. I don't think it is possible to open any IFS form from PL/SQL at any moment. Please correct me if I'm wrong.
Maybe IFS10 and before and IFS Cloud differ here.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.