[SOLVED] Assistance wilth dynamically position a subfooter
Hello, I have the requirement to dynamically position the subfooter based on weather or not a parameter was selected from the launch page and I was wondering if I can use 'IF' lodgic while printing out my subfooter. I have tried...with no success. The issue that I have is that their are two fields from the launch page that I'll have to check (MERCHANTID and ASSOCIATIONID)...the situation is that one or both of these fields might be populated. can someone think of a way that I might be able to accomplish this. Will I need three stylesheets that are dynamically refferenced. my code my code is listed below:
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=2, POSITION=P5,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=3, POSITION=P6,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=4, POSITION=P7,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=5, POSITION=P8,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=6, POSITION=P9,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=7, POSITION=P10,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=8, POSITION=P11,JUSTIFY=RIGHT,STYLE=BOLD, $
TYPE=SUBFOOT, LINE=1, WHEN=&MERCHANTID.EVAL NE ' ',ITEM=9, POSITION=P12,JUSTIFY=RIGHT,STYLE=BOLD, $
ThanksThis message has been edited. Last edited by: Kerry,
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC
July 13, 2009, 01:10 PM
tlbrydie2
The format for this report is PDF
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC
July 13, 2009, 02:12 PM
Darin Lee
Tim,
You're on the right track with the &variable. Easiest would be to use an &var for the POSITION value:
-SET &POSIT1=IF &MERCHANTID NE '' THEN 'P5' ELSE 'wherever it would otherwise go'; -SET &POSIT2=IF &MERCHANTID NE '' THEN 'P6' ELSE 'wherever it would otherwise go';
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 13, 2009, 02:27 PM
tlbrydie2
Darin,
Thanks for your assistance. I'll mark this as [solved].
Have a great day!
Timothy
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC