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 IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?
Can we invoke one form from another in a multi-forms application?
What package procedure used for invoke sql plus from sql forms ?
What is the difference when Flex mode is mode on and when it is off?
Which is the cheapest and quality Oracle Education provider in Bangladesh?
difference between repeating frame and frame
What is the use of transactional triggers?
What is AppCore and AppCore2 ?
What are the different types of Package Procedure ?
i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com
in before report trigger SRW.user_exit(FND_Userinit) what will do
At what point of report execution is the before Report trigger fired?