how will the report recognize the parameter
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?
| Is This Answer Correct ? | 1 Yes | 0 No |
all steps of bitmap report?
What are the built -ins used for Modifying a group's structure?
I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....
What is a combo box?
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
Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;
Explain how can you use the same lov for 2 columns?
What is a Non Query Record Group?
what are difference between post database commit and post-form commit?
what u write in Ctl file
Can you change the alert messages at run-time?
What is a predefined exception available in forms 4.0?