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 are the various configuration files that are used by oracle forms?
What is a timer?
What is a Trigger ?
What is a physical page ? & What is a logical page ?
What is the use of place holder column?
What package procedure used for invoke sql plus from sql forms ?
plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
Suppose I want to fire block level sequence before form level, then is it possible?
suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?
Which parameter can be used to set read level consistency across multiple queries?