How to create multi-layout reports ? If we have 5 layouts ,
then how to get into the 4th one ?
Answers were Sorted based on User's Feedback
Answer / prakash
if u have 5 layouts u nedd 4th one.then do one thing.
first create the 5 layouts.after thet create one user
parameter.and u will wtite formate trigger for each layout.
after that u will run the report.then that user parameter
wiil ask some value/character. then u will give which name
u r giving 4th layout.
regards,
prakash.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / 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 |
Is SOB is attached with Business grp ?
What do you understand by soa and what are the benefits of using this architecture?
Can functions be overloaded ?
What are Mandatory triggers to write in the block, which is created on view?
How to print invoice from APPS(front end).if we have invoice number in hand with us???
Name the different Cursor Attributes.
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
what is the difference between credit memo and debit memo?...
what is meant by Table space?
what is the diff between custom.pll and form personalization? Tell me one example?
What is the interface?
What are the benefits of using soa architecture?