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
What are the Standard Reports and Forms in HRMS?
Can you define an erp system?
What is the concept of soa governance?
What are the different components of soa suite?
How can a process be deployed in soa?
In oracle application how do you debug or trace errors?
In hierarchical structure of a database? we have write query from where we should start?
is it possible to run the interface without using oracle apps?
Can you explain the difference between architecture followed in 10g & 11g?
Tell me how to debug the report?
How can you achieve loose coupling in soa framework?
Can we create tables in apps schema?
what is global tempory table?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
Tell me how to find the custom directory in front end?