Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Styling of table footing

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Styling of table footing
 Login/Join
 
Virtuoso
posted
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
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
It works fine in 7.6.4 ON LINUX and 5.3.6 on windows.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Styling of table footing

Copyright © 1996-2020 Information Builders