I have assumed responsibility for a program written by someone else that uses tons of SUBHEADs and SUBFOOTs in order to create a very detailed report with tons of breaks for subtotals. The client wants me to add another SUBFOOT based on the same SORT field but have completely different styling.

-*NOTE: I HAD TO PUT REPLACE < with * in front of the subfooted vals b/c the forum website wouldn't show this info.
-*this is existing from rb
ON REPORT_DATE SUBFOOT
"*TXT1 *DAY_BALANCE"
"*TXT2 *
-*this is new from me
ON REPORT_DATE SUBFOOT
"*USERNOTE1"
"*USERNOTE2
...other code here... but I MUST put the NOTEx ON REPORT_DATE b/c then it doesn't get placed properly on the output....

...here is where the styling comes in ....

ON TABLE SET HTMLCSS ON
ON TABLE &HOLDTYPE AS RPTDETL FORMAT &FORMAT
ON TABLE SET ASNAME ON
ON TABLE SET ALL ON
ON TABLE SET STYLE *

TYPE=REPORT, GRID=OFF, WRAP=OFF, SQUEEZE=OFF, COLOR=RGB(1 1 1),
PAGESIZE=LETTER, TOPMARGIN=.01, LEFTMARGIN=.15, RIGHTMARGIN=.15,
FONT=ARIAL, SIZE=8, TITLETEXT='Cash Detail',$

-*heading styles have been removed temporarily


-*I color-coded each value so I can see where the styling is really happening
TYPE=SUBFOOT,BY=REPORT_DATE, HEADALIGN=BODY,STYLE=NORMAL,$
TYPE=SUBFOOT,BY=REPORT_DATE, OBJECT=FIELD,LINE=1,ITEM=1, STYLE=BOLD,
POSITION=.5, COLSPAN=2,COLOR=PURPLE,$
TYPE=SUBFOOT, BY=REPORT_DATE, OBJECT=FIELD, LINE=1, ITEM=2, STYLE=BOLD,
JUSTIFY=RIGHT, COLOR=PINK,$
TYPE=SUBFOOT, BY=REPORT_DATE, OBJECT=FIELD, LINE=2, ITEM=1, STYLE=BOLD,
POSITION=.5, COLSPAN=2, COLOR=SILVER,$

-*now...here is the style that is supposed to only be for the 2nd subfoot on report_date
TYPE=SUBFOOT,BY=REPORT_DATE, OBJECT=FIELD,LINE=1, COLOR=ORANGE,
POSITION=3,WRAP=5,COLSPAN=5,
WHEN=USERNOTE1 NE ' ',$

-*

when I run this, the first style is always in control for everything on line stays pink including the one that s/b orange.

Any ideas?
Thanks

This message has been edited. Last edited by: cmallain,

------------------------------------------
last version used: v7.1; truly miss the wonderful things I did with WebFOCUS, HTML, & JavaScript.

http://techsupport.informationbuilders.com/sps/92441113.html

From the solutions center as applies to pdf anyway.

yes, I just confirmed that my code works great with PDF but is there a way to do this same thing with HTML?

Actually PDF works fine without the POSITION attributes.

Also, I'm already using POSITION to move the placement of the SUBFOOTS x # of units. Can I use 2 POSITION attributes?

C..

POSITION does not work in HTML, you can use the grid but that works a bit different.

in the subfoot you can say

"this is a subfoot<+0><ST.SALES<+0><ST.COUNT"

In the stylesheet you can position all the items on one line, change the color etc (but not the background color).

Do you use Developer Studio?

Click right in the subfoot area and look for "grid"
you get a spreadsheet like raster.

Hi Frank,

No I do not have Dev Studio...actually this is all being done via the mainframe. I think a co-worker has fixed my problem though. He basically told me to build the SUBFOOT using a WHEN for both conditions so I have to repeat the SUBFOOT command and then put a WHEN x EQ y on the 1st and a WHEN x NE y on the 2nd. This way the stylesheet knows which one is in control so with that thought in mind...


-*NOTE: I HAD TO PUT REPLACE < with * in front of the subfooted vals b/c the forum website wouldn't show this info. Not sure why...
-*this is existing
ON REPORT_DATE SUBFOOT
"*TXT1 *DAY_BALANCE"
"*TXT2 *MONTH_BALANCE"
WHEN USERNOTE1 EQ ' ';

-*this is new from me
ON REPORT_DATE SUBFOOT
"*TXT1 *DAY_BALANCE"
"*TXT2 *MONTH_BALANCE"
"*USERNOTE1"
"*USERNOTE2"
WHEN USERNOTE1 NE ' ';

-*...here is where the styling comes in ....

ON TABLE SET HTMLCSS ON
ON TABLE &HOLDTYPE AS RPTDETL FORMAT &FORMAT
ON TABLE SET ASNAME ON
ON TABLE SET ALL ON
ON TABLE SET STYLE *

TYPE=REPORT, GRID=OFF, WRAP=OFF, SQUEEZE=OFF, COLOR=RGB(1 1 1),
PAGESIZE=LETTER, TOPMARGIN=.01, LEFTMARGIN=.15, RIGHTMARGIN=.15,
FONT=ARIAL, SIZE=8, TITLETEXT='Cash Detail',$

-*heading styles have been removed temporarily

-*I color-coded each value so I can see where the styling is really happening
TYPE=SUBFOOT,BY=REPORT_DATE, HEADALIGN=BODY,STYLE=NORMAL,$
TYPE=SUBFOOT,BY=REPORT_DATE, OBJECT=FIELD,LINE=1,ITEM=1, STYLE=BOLD,
POSITION=.5, COLSPAN=2,COLOR=PURPLE,$
TYPE=SUBFOOT, BY=REPORT_DATE, OBJECT=FIELD, LINE=1, ITEM=2, STYLE=BOLD,
JUSTIFY=RIGHT, COLOR=PINK,$
TYPE=SUBFOOT, BY=REPORT_DATE, OBJECT=FIELD, LINE=2, ITEM=1, STYLE=BOLD,
POSITION=.5, COLSPAN=2, COLOR=SILVER,$
TYPE=SUBFOOT, BY=REPORT_DATE, OBJECT=FIELD, LINE=2, ITEM=2, STYLE=BOLD,
POSITION=.5, COLSPAN=2, COLOR=BLUE,$

-*now...here is the style that can now be specified for lines 4 & 5 instead of
-* trying to restate lines 1 & 2....so...
-* lines 4 & 5 will ONLY display if the NOTES field is NOT blank and therefore
-* styling s/b properly applied.
-*NOTE: line3 is a blank line after the balance so don't need to style.
TYPE=SUBFOOT,BY=REPORT_DATE, OBJECT=FIELD,LINE=4, COLOR=ORANGE,
POSITION=3,WRAP=5,COLSPAN=5,
WHEN=USERNOTE1 NE ' ',$
TYPE=SUBFOOT,BY=REPORT_DATE, OBJECT=FIELD,LINE=5, COLOR=SILVER,
POSITION=3,WRAP=5,COLSPAN=5,
WHEN=USERNOTE1 NE ' ',$

if you put your script within

[CODE]
here comes the coding with < ...

[/CODE]
you can type the code characters

Hi Frank,

Thanks for the

 ...   

idea. I'll try it next time.

Carol