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
Explain how one can iterate through items and records in a specified block?
Is it possible to have multiple layouts in a report?
i am writing a query select EmpNo from Emp how can i call in after parameter form
Name the different triggers supported by oracle reports and their firing order.
how do u compile a form i.e .fmb file in Unix or in dos
How can we generate report output in excel format?
What is the difference between flex mode and confined mode?
what exactly u write in when_new_form_instance
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
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
what are the new features introduced in oracle form services in 11g release 2?
Can we invoke one form from another in a multi-forms application?
if u want to delete all these detail block etc what will happen in form
What do you understand by oracle forms?
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
