Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how do u call a report from form

Answers were Sorted based on User's Feedback



how do u call a report from form..

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 do u call a report from form..

Answer / kiran

by using RUN_PRODUCT build-in

Is This Answer Correct ?    9 Yes 1 No

how do u call a report from form..

Answer / manojit

Answer is correct

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More Oracle Forms Reports Interview Questions

What are the various configuration files that are used by oracle forms?

0 Answers  


What is a timer?

1 Answers  


What is a Trigger ?

1 Answers  


What is a physical page ? & What is a logical page ?

2 Answers   Techbooks,


What is the use of place holder column?

1 Answers  


What package procedure used for invoke sql plus from sql forms ?

1 Answers  


plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example

2 Answers  


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

0 Answers   Convergys,


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

0 Answers  


Suppose I want to fire block level sequence before form level, then is it possible?

1 Answers  


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?

2 Answers   Oasis,


Which parameter can be used to set read level consistency across multiple queries?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)