how do u call a report from form
Answers were Sorted based on User's Feedback
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 |
What ERASE package procedure does ?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
how to pass 2 parameters from one form to other in oracle applications?
What are the various sub events a mouse double click event involves?
What is an LOV?
What Enter package procedure does ?
what exactly u write in when_new_form_instance
What is a predefined exception available in forms 4.0?
explain tkprof?
Can you pass data parametrs to forms?
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?
What is lexical reference?How can it be created?