Answer / sudipta santra

The recognization of the parameter by the report is given
below as step by steps:

1. Report checks any bind variable be used in Data model
query, if found then check the is there any parameter with
the same name of that bind bariable with the matching
datatypes or not ? It is one of the ways.

2. If the first point is not feasible i.e, no bind variables
are used, so then report checks any reference item columns
in layout editor where the item is not related to the column
of the query data model, if found then as the same way it
checks any same name parameter is used or not with the same
datatype ? It is the another way of recognize.

3. If the above two points are not feasible then reports
checks any formula column or placeholder column or summary
column is in data model where any bind variable is used if
found then in the same way of the above 2 points report
recognize.

Got it?

What is the User-Named Editor?

1 Answers  

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

0 Answers  

---

What are the built-ins used for processing rows?

1 Answers  

---

What do you understand by lov?

0 Answers  

---

where do u put the report file

0 Answers  

---

What is the difference between flex mode and confined mode?

0 Answers  

---

What are the built-ins used for finding object ID functions?

2 Answers  

---

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

1 Answers  

---

How can you hide the report in Apps?

1 Answers  

---

how will the report recognize the parameter

1 Answers  

---

What are User Exits and what are different types of User Exits in Oracle Apps ?

2 Answers  

---

What is a Text_io Package?

4 Answers  

---