Focal Point
Styling of table footing

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

January 17, 2008, 05:21 AM
GamP
Styling of table footing
A bit of a wierd problem.
If i run the below code with output html I get each line of the table footing in three colors.
But when I run the same code with output PDF, each line is colored with the same color.
Is there a way that you konw of to get the lines to display as they do in html?

Code used:
TABLE FILE CAR
PRINT
     CAR
     MODEL
BY COUNTRY
ON TABLE SUBFOOT
" <+0> <+0> TEXT LINE 1"
" <+0> <+0> TEXT LINE 2"
" <+0> <+0> TEXT LINE 3"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT html/pdf
ON TABLE SET STYLE *
     UNITS=IN,     SQUEEZE=ON,     ORIENTATION=PORTRAIT,$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, STYLE=NORMAL,$
TYPE=TABFOOTING, LINE=1, OBJECT=TEXT, ITEM=1, BACKCOLOR='RED',   WIDTH=1.25, $
TYPE=TABFOOTING, LINE=1, OBJECT=TEXT, ITEM=2, BACKCOLOR='GREEN', WIDTH=1.25, $
TYPE=TABFOOTING, LINE=1, OBJECT=TEXT, ITEM=3, BACKCOLOR='BLUE',  WIDTH=3.25, $
TYPE=TABFOOTING, LINE=2, OBJECT=TEXT, ITEM=3, BACKCOLOR='RED',   WIDTH=3.25, $
TYPE=TABFOOTING, LINE=2, OBJECT=TEXT, ITEM=2, BACKCOLOR='GREEN', WIDTH=1.25, $
TYPE=TABFOOTING, LINE=2, OBJECT=TEXT, ITEM=1, BACKCOLOR='BLUE',  WIDTH=1.25, $
TYPE=TABFOOTING, LINE=3, OBJECT=TEXT, ITEM=1, BACKCOLOR='RED',   WIDTH=1.25, $
TYPE=TABFOOTING, LINE=3, OBJECT=TEXT, ITEM=2, BACKCOLOR='GREEN', WIDTH=1.25, $
TYPE=TABFOOTING, LINE=3, OBJECT=TEXT, ITEM=3, BACKCOLOR='BLUE',  WIDTH=3.25, $
ENDSTYLE
END

Any ideas?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
January 17, 2008, 05:58 AM
FrankDutch
G

I have the same problem.
after lunch I have a meating with Marco our IBI accountmanager. I will ask if he knows the solution.... Music




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 17, 2008, 06:10 AM
Tony A
Gamp,

If I run this against my Client's config (without change) for PDF then I get the same results as per HTML output - which is one colour per line Frowner

Surely it can't be a 7.6.2 change of function?

T

This message has been edited. Last edited by: Tony A,



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 17, 2008, 06:42 AM
GamP
Frank, doe Marco W maar de groetjes van me.

Tony, I've tested this in just about every recent release, and it all comes out the same for me: 3 colors per line for htm, 1 color per line for pdf.
Haven't tried excel (yet). I wonder what the result will be there.....


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
January 17, 2008, 09:40 AM
GinnyJakes
I also tested on 762 and it works fine with both formats.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
January 17, 2008, 12:58 PM
Leah
It works fine in 7.6.4 ON LINUX and 5.3.6 on windows.


Leah
January 17, 2008, 01:12 PM
Tony A
Ginny, Leah,

Did you make the same oversight as I did first time around? There should be three different colours on each footing line - not the single colour.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 17, 2008, 01:23 PM
Tony A
On 7.1.3, I have to add "ON TABLE SET HTMLCSS ON" to get the three colours per line in HTML. Still only red - blue - red in PDF though.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 17, 2008, 02:35 PM
GinnyJakes
You're right, Tony. I get red-blue-red across the whole line. I played around with moving the spot markers with no success.

So then I went into the Report Painter and used the new 'Alignment Grid' option, didn't fool around with any justification, and I got the 3 colors on a single line with HTML but not PDF.

Here is the code:
TABLE FILE CAR
PRINT 
     CAR
     MODEL
BY COUNTRY
ON TABLE SUBFOOT
"TEXT<+0>Line<+0>1"
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     BACKCOLOR='RED',
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     BACKCOLOR='GREEN',
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     BACKCOLOR='BLUE',
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
ENDSTYLE
END
 


This is the opposite of what GamP is getting.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
January 22, 2008, 02:32 AM
GamP
No Ginny, it's exactly what I get on all releases and platforms I have access to.
I think I'll open a case with IBI for this.
By the way, excel outpout behaves the same as PDF, one color per line.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988