Answer Posted / 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?
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
from where do u receive the information to develop report
what are the new features introduced in oracle form services in 11g release 2?
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
How can we generate report output in excel format?
where do u put the report file
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
can you convert or reverse engineer a fmx back to a fmb file?
Explain the various types of oracle report?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
In what situation u create the BPA.
what are the oracle forms services components include?
What do you understand by oracle forms and why are they required?
What do you understand by oracle forms?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output