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 |
How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.
Can a property clause itself be based on a property clause?
Why oracle forms required?
What are the types of Pop-up window ?
What is the difference between OLE Server & Ole Container?
can you change the default value of the radio button group at run time?
how to pass 2 variables from one form to other form
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
What is user exit.?
2 Answers IBM, Synergy, Zensar,
What package procedure is used for calling another form ?
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?