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
Name the different triggers supported by oracle reports and their firing order.
What are the various configuration files that are used by oracle forms?
what is a package n what r the packages availbla in report
Explain the different levels at which oracle form services interact.
how report can be generated if we have the database designed in oracle 10g?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
What is the difference between BPA AND Contract What are documents and test cases u followed
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
Can we invoke one form from another in a multi-forms application?
What do we mean by record group in oracle forms?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
what is oracle forms?
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
Is it possible to execute a dynamic sql from forms?