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 |
Which parameter can be used to set read level consistency across multiple queries?
How i get the client m/c IP address.
Does a grouping done for objects in the layout editor affect the grouping done in the datamodel editor?
Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?
Can you pass data parametrs to forms?
how to pass 2 variables from one form to other form
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size? If yes,how?
What is trigger associated with the timer?
List the buil-in routine for controlling window during run-time?
List out the oracle forms configuration files?
Explain how one can iterate through items and records in a specified block?
What is a Trigger ?