Monday 12 August 2013

How To create two or more layout in report 6i?

Create 2 layouts each in a separate main frame.
Create these 2 main frames one below the other. No layout should cross x-axis and Y-axis.
After that create one user parameter and write a format trigger on all the main frames.
--In format trigger of first Main frame mention for first layout to display
if :p_parameter = 1 then
return true;
end if;  
--In format trigger of second Main frame mention for Second layout to display
if :p_parameter = 2 then
return true;
end if;
Similarly write format triggers for all the remaining main frames.
When you run the report, Based on the value you provide for p_parameter the format trigger
will display only one frame If You enter p_parameter value as 1 then first layout willbe displayed as output.
If You enter p_parameter value as 2 then second layout willbe displayed as output.
Create anchors between the frames, so that there won’t be any space left when other frames are not displayed.

No comments:

Post a Comment