how do u call a report from form

Answers were Sorted based on User's Feedback



how do u call a report from form..

Answer / lokanatha reddy

Using RUN_PRODUCT Built in we can call a Report from a Form.
It will take 7 Parameters as follows
1) Product name :: REPORT/GRAPHICS
2) Module name :: Report name
3) Communication Mode :: Synchronous /Asynchronous
SYN :: we cannot work with the Form until and unless you
closes the Report.
Asyn:: We can work with Form & Reprot (Navigate)

4) Exec :: Batch/Run time
Batch :: it will fetch all records at a time
Run time :: It will fetch only one Record at a time
5) File name :: database/Filesystem
6) Parameters :: Report Parameters
7) Display :: For Graphics (Mostly null)
Ex :: If i have :p_deptno parameter then we can call as
Follows
RUN_PRODUCT
('REPORT','C:\TEST1.rep',SYN,BATCH,DATABASE,p_deptno,' ');

Is This Answer Correct ?    16 Yes 2 No

how do u call a report from form..

Answer / kiran

by using RUN_PRODUCT build-in

Is This Answer Correct ?    9 Yes 1 No

how do u call a report from form..

Answer / manojit

Answer is correct

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Oracle Forms Reports Interview Questions

What ERASE package procedure does ?

1 Answers  


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

0 Answers  


how to pass 2 parameters from one form to other in oracle applications?

1 Answers  


What are the various sub events a mouse double click event involves?

1 Answers  


What is an LOV?

2 Answers  






What Enter package procedure does ?

1 Answers  


what exactly u write in when_new_form_instance

0 Answers   TCS,


What is a predefined exception available in forms 4.0?

1 Answers  


explain tkprof?

1 Answers   Convergys,


Can you pass data parametrs to forms?

1 Answers  


There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?

3 Answers   3i Infotech,


What is lexical reference?How can it be created?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)