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


Please Help Members By Posting Answers For Below Questions

tell me the scenarios of the independent in reports

2037


List the types of flexfield?

596


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

1559


Can we create tables in apps schema?

610


can we get profile values in report without using user exists is it possible how?

2310






How can we import the data into a database using sql * loader?

673


What do you understand by a set of books?

639


In oracle application how do you debug or trace errors?

623


how do you describe O2C along with tables

2307


Tell me how to debug the report?

629


testing tools?

1741


what is the differences between internal requisition and internal sales order?

2147


please send me forms, xml pulisher questions,answers

1647


where to define interorganization transaction charges and what are the different options?

1941


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2120