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
what is a package n what r the packages availbla in report
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
from where do u receive the information to develop report
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
what is difference between group above and group left report
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
what is the difference between call_form, new_form and open_form?
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
Is it possible to have multiple layouts in a report?
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
What is an SQL FORMS ?
Name the different triggers associated with oracle forms having a master-detail relationship.
Explain how can you use the same lov for 2 columns?
how to send file attachment from oracle forms
where do u put the report file