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...