Saving a report to a file on a client PC?

oracle oracle10g oracleforms oraclereports
Ian Carpenter picture Ian Carpenter · Jul 8, 2010 · Viewed 7.5k times · Source

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 if an Oracle Report is run in such a format as PDF the user can save the report to x location). To call the Oracle report I am using the Oracle Forms built-in "Run_Report_Object".

I don't think it is (but would be happy to revise my opinion!) and to obtain such functionality I would have to implement something similar to what is discussed in this thread

Answer

Ian Carpenter picture Ian Carpenter · Jul 9, 2010

I have amended my question to include the fact that I am using the Oracle Forms built-in "Run Report Object" to call Oracle Reports.

There is a Oracle Report parameter: DESTYPE which can accept a value called LOCALFILE which saves the output to the client machine using the file name specified by DESNAME, however as I'm using "Run_Report_Object" it is not possible to use the value LOCALFILE.

One solution is to follow the steps given here.

Sources: Oracle Reports 10g Help (look for DESTYPE), OTN thread

Related questions

Viewing oracle app and getting: java.lang.ClassNotFoundException: oracle.forms.engine.Main

I'm trying to debug an oracle forms application. In production, when I load the application I get an error: java.lang.ClassNotFoundException: oracle.forms.engine.Main I'm uncertain as to what is causing this issue. I've been searching forums for …

Read More
How to retain block position after a query -oracle forms

I have an oracle form with a data_block which displays 25 items. On the form I have a scrollbar and a 'delete' button. When an item in the data block is selected, and the 'delete' button is pressed, it deletes …

Read More
How to read the PL/SQL code in an Oracle Forms .FMT file?

Oracle Forms10g provides a tool to convert the Oracle Forms modules, from the binary format (.FMB) that Oracle Forms Builder works with, to text format (.FMT). For example, if you create a module called mymodule.fmb with Oracle Forms …

Read More