how do u call a report from form

Question Posted / arpitha2206

3 Answers
11515 Views
Wipro, I also Faced
E-Mail Answers

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 is place holder column

3 Answers Oracle, PCS,

BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT. WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES TOTAL SHOULD BE DISPLAYED

1 Answers

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

2 Answers

how to create the triggers in the forms?

3 Answers

what are different types of canvas views?

3 Answers

When is PRE-QUERY trigger executed ?

3 Answers

What is the difference between system.current_field and system.cursor_field ?

3 Answers

How can you format a character field in a report Layout editor ?