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 unit of measure classes? give atleast two examples. name the underlying table.
what are the different transaction clauses in AR?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Can you have two stored functions with in the same name?
maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
wht r the basetables of customer interface?
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
mention the interface tables for item open interface and open transaction interface and also their respective production tables.