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.
|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
--In format trigger of Second Main frame you will mention
-- for Second layout to display
if :p_parameter = 2 then
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|
Answer / viswa
using format trigger we can spesific layout
|Is This Answer Correct ?||8 Yes||0 No|
How to link modules in apps
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
what is pl/sql table and pl/sql records? what is the use of that?
how can we return morethan one parameters in procedure?
suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?
What do you understand by soa?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
define steps of assigning items to an organization.
where u do setup of operating unit?
Difference between Bind and Lexical parameters?
How you will Diaplay the Company LOGO In report.Can anyone knows please give solution
where we will put the control file ,where we will run sql star loader what is the cmd?