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 |
What is an Index , Types od index why we are use index.
wht is difference between is and as varibales,while declaring procedure which is better?
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
what is difference between d2k report and oracle apps report
What is the use of format trigger?
What is invoice?
do i need to declare bind parameter before using in the query?
Do you know what are user profiles in apps. Any examples you can give?
what is Flex mode and Confine mode?
How can you achieve loose coupling in soa framework?
Is there any limitations on responsibility assigned to a apps user?
WHAT IS REFCURSOR IN ORACLE ?