Interested to Buy Any Domain ? << Click Here >> for more details...
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
how report can be generated if we have the database designed in oracle 10g?
Explain the various types of oracle report?
List the different types of columns in oracle reports.
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
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
Name the different triggers associated with oracle forms having a master-detail relationship.
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
how do u compile a form i.e .fmb file in Unix or in dos
What do you understand by oracle forms and why are they required?
all steps of bitmap report?
What is the difference between BPA AND Contract What are documents and test cases u followed
what are the oracle forms services components include?
What is an oracle report? List its various types.
how do u place it in required folder
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
