Focal Point
[SOLVED] Assistance wilth dynamically position a subfooter

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/805105971

July 13, 2009, 12:59 PM
tlbrydie2
[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:

This is my origional code:
  
-* this is the origional
-*TYPE=SUBFOOT, BY=2, LINE=1, ITEM=1, POSITION=P2,STYLE=BOLD, $
-*TYPE=SUBFOOT, BY=1, LINE=1, ITEM=1, POSITION=P1,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=2, POSITION=P6,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=3, POSITION=P7,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=4, POSITION=P8,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=5, POSITION=P9,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=6, POSITION=P10,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=7, POSITION=P11,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=8, POSITION=P12,JUSTIFY=RIGHT,STYLE=BOLD, $
-*TYPE=SUBFOOT, LINE=1, ITEM=9, POSITION=P13,JUSTIFY=RIGHT,STYLE=BOLD, $


However now I need to do something like:

  
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, $ 



Thanks

This 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';

and then you would have in your stylesheet

TYPE=SUBFOOT, LINE=1, ITEM=2, POSITION=&POSIT1 ,JUSTIFY=RIGHT,STYLE=BOLD, $

TYPE=SUBFOOT, LINE=1, ITEM=3, POSITION=&POSIT2 ,JUSTIFY=RIGHT,STYLE=BOLD, $


Regards,

Darin



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