Interested to Buy Any Domain ? << Click Here >> for more details...
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
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 exactly u write in when_new_form_instance
Name the different triggers associated with oracle forms having a master-detail relationship.
if u want to delete all these detail block etc what will happen in form
how to send file attachment from oracle forms
What is the difference between flex mode and confined mode?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
can you convert or reverse engineer a fmx back to a fmb file?
how do u place it in required folder
What do we mean by record group in oracle forms?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
List the different types of columns in oracle reports.
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
What is responsibility and how u attach How to create user and how u attach with responsibility.
what is the difference between call_form, new_form and open_form?
