Answer Posted / sudipta santra
1. In Report's Data model part, click on Placeholder column
from toolbox, then a placeholder column will be created with
default name CP_1 as like if u want u can change the name.
2. Go to the PL/SQL by right clicking on the newly created
placeholder column in data model.
function CP_1Formula return char
begin
return null;
end;
3. Click on Formula column from toolbox, then a formula
column will be created with the default name CF_1/CF_2 as
like that, if u want u can change it's name.
4. Go to the PL/SQL by right clicking on the newly created
formula column in data model.
function CF_1Formula return number
begin
if :stock<10 then
:CP_1:= 'Too less stock';
elsif :stock<50 and :stock>10 then
:CP_1:= 'Average stock';
else
:CP_1:= 'Good stock';
end if;
return 1;
end;
Note: Here the placeholder column is used with the null
carrying result but when the formula be used then the
placeholder will get value and will carry this in report.
And also we can use this anywhere in report as according
application requiremnt needs.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
what is tripstop report?
What is the difference between bind and lexical parameter?
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
List out the oracle forms configuration files?
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
how do u compile a form i.e .fmb file in Unix or in dos
What is the difference between flex mode and confined mode?
Explain the different levels at which oracle form services interact.
What is a canvas in oracle forms?
What is an SQL FORMS ?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
what are bind variables?
What do you understand by oracle forms and why are they required?
