How to create multi-layout reports ? If we have 5 layouts ,
then how to get into the 4th one ?
Answer Posted / altaf a shaikh
first create the 5 layouts.Create each layout in a separate
Main frame.You can create 5 main frames one below the
other.No layout should cross x-axis and Y-axis.After that
create one user parameter. and u will wtite formate trigger
for each Main Frame format trigger.
after that u will run the report.
--In format trigger of first Main frame you will mention
-- for first layout to display
if :p_parameter = 1 then
return true;
end if;
--In format trigger of Second Main frame you will mention
-- for Second layout to display
if :p_parameter = 2 then
return true;
end if;
perform above task for remaining 3 main frames.
when You run report.
If You enter p_parameter value as 1 then first layout will
be displayed as output.
If You enter p_parameter value as 2 then second layout will
be displayed as output.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
tell me the scenarios of the independent in reports
List the types of flexfield?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Can we create tables in apps schema?
can we get profile values in report without using user exists is it possible how?
How can we import the data into a database using sql * loader?
What do you understand by a set of books?
In oracle application how do you debug or trace errors?
how do you describe O2C along with tables
Tell me how to debug the report?
testing tools?
what is the differences between internal requisition and internal sales order?
please send me forms, xml pulisher questions,answers
where to define interorganization transaction charges and what are the different options?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?