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
Explain oracle apps architecture.
can we use look up type instead of a pofile option?or valueset?is it possible how?
how to print multi lay outs,muti currency,muti language in xml publisher
tell my any difficult situtation you solved in your experience in your company?
What do you understand by soa and what are the benefits of using this architecture?
In hierarchical structure of a database? we have write query from where we should start?
What is sca and how is it useful?
is it possible to run the interface without using oracle apps?
How many schemas we have? how many you have used?
do you know is it possible to run the interface without using oracle apps?
Can we create tables in apps schema?
How to move the one file from one instance to another instance? And your scripts also?
How can a process be deployed in soa?
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
how can develope the po variance and po summary report? with tables mandatory columns and query please?