export PDF from report directly

oracle oracleforms oraclereports
Amir picture Amir · Dec 27, 2010 · Viewed 7.4k times · Source

I use Oracle Report 6 for get my report, The problem is I want to get PDF export without displaying the report.I mean right now, I click on one button and make report (call a report from my Oracle form) then go to my report menu ->Generate to File -> PDF.

I dont want do this anymore... can I use any command from my form to export my report directly? I mean for example use some command to prepare report and get export in PDF automatically...

also if I can set the export file name and it's location when I try to generate PDF also can help me so much because I need to follow some rule for put name for my export files like use prefix and some digit and number....

What is your suggestion?

Answer

Manim picture Manim · Dec 29, 2010

You can do both request.

You have to create parameter and pass to run_product built-in

Syntax:

REPORT_DESTYPE: File, Printer, Mail, Cache   -- SET File
REPORT_FILENAME: The report filename (not used with CACHE)  -- Set your desirable file name format
REPORT_DESNAME: The report destination name (not used with Cache) -- 
REPORT_DESFORMAT: The report destination format  -- <HTML|HTMLCSS|PDF|RTF|XML|DELIMITED> set PDF

Sample parameter list: SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT, '');

I hope this help.

If you still need full details let me know, i'll add a sample procedure.

Related questions

Migrating Oracle forms and report application from 10g to 12c

We have a oracle forms and reports application build in 10g. We are planning to migrate the application to 12c from 10g. can we simple compile the forms in 12c like we do in 10g ? or we need to re …

Read More
Saving a report to a file on a client PC?

I would be grateful for a quick sanity check! When calling Oracle Reports 10g from Oracle Forms 10g, is it possible to run an Oracle Report and save it on the users PC to a specified directory? (I know that …

Read More
Oracle Forms/Applications in Internet Explorer 8 using JInitator

Has anyone been able to get Oracle Forms running JInitator to loan in Internet Explorer 8 yet? I have tried removing all add-ons, various version of Java, add the domain to the trusted sites using wildcards, and using compatibility mode to …

Read More