Oracle development with PeopleSoft will enable knowledge and configuration experience to showcase in this group. Share updates with consultants and engineers.
There was a need to put two different foot note in SQR Reports based on the page orientation (Landscape or Portrait). For this situation, we can creat one SQC using #if and PAGE_ORIENTATION variable defined in our standard setup01a.sqc, setup02a.sqc etc. The SQC lines are given below.
Oracle PeopleSoft Development
110 members
Description
Oracle development with PeopleSoft will enable knowledge and configuration experience to showcase in this group. Share updates with consultants and engineers.
begin-footing – two different foot note in one SQC
by Merrilee Marton
Dec 2, 2013
There was a need to put two different foot note in SQR Reports based on the page orientation (Landscape or Portrait). For this situation, we can creat one SQC using #if and PAGE_ORIENTATION variable defined in our standard setup01a.sqc, setup02a.sqc etc. The SQC lines are given below.
#if {PAGE_ORIENTATION} = ‘PORTRAIT’
begin-footing 2
print ‘Important Note: 1′ (1,1)
!Add more lines as needed
end-footing
#else
#if {PAGE_ORIENTATION} = ‘LANDSCAPE’
begin-footing 2
Read Further: http://psadmin.wordpress.com/2008/09/14/begin-footing-two-different...