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 |
why do we validate the records while developing interface?
while running a interface if we get 100 records as erors. how to debug it.
What is GLOBAL TEMPORARY TABLE and It's significance ?
oracle apps architecture
which is the table for storing organization information?
9 Answers Infosys, Scan Steel,
what is instead of trigger in where u will use?
How many typres of Purchase order and what are those.
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
What is multoorg and what is it's level or structure
please send me forms, xml pulisher questions,answers
Can you define an erp system?
how can i print random rows in plsql table