Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Styling issue with TYPE=DATA
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Styling issue with TYPE=DATA
 Login/Join
 
Platinum Member
posted
Hi,

I have a report with few columns and rows and BACKCOLOR is applied to ROWS using the below code.

  
TYPE=DATA,
BACKCOLOR=( RGB(242 220 219) RGB(230 184 183) ),
WHEN=CITY EQ '1',
$


I also have to apply a different color to the last ROW.
So i have,
  
TYPE=DATA,
BACKCOLOR=RGB(150 54 52),
WHEN=ROWID EQ 1,
$


ROWID is a compute field which is set to 1 when it is the last row.
But when i run the report i see that the first styling is applied and the styling from the second part is not applied.

Also i noticed that if i mention each column in the second styling as below,the styling from the second part is applied.
TYPE=DATA,
	COLUMN=COL_NAME,
	BACKCOLOR=RGB(150 54 52),
	WHEN=ROWID EQ 1,
$


Is there any workaround to implement this without mentioning the column name.

This message has been edited. Last edited by: FP Mod Chuck,


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 207 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Try one of the following:
One DATA and two WHEN statements
  
TYPE=DATA,
BACKCOLOR=( RGB(242 220 219) RGB(230 184 183) ), WHEN=CITY EQ '1', $
BACKCOLOR=RGB(150 54 52), WHEN=ROWID EQ 1, $


Invert the DATA statements
  
TYPE=DATA,
BACKCOLOR=RGB(150 54 52), WHEN=ROWID EQ 1, $

TYPE=DATA,
BACKCOLOR=( RGB(242 220 219) RGB(230 184 183) ), WHEN=CITY EQ '1', $



Use a loop to create many DATA statements
 
-REPEAT #PLOOP FOR &I FROM 1 TO 50;
TYPE=DATA, COLUMN=P&I, BACKCOLOR=RGB(150 54 52), WHEN=ROWID EQ 1, $
-#PLOOP

Even if you do not have 50 output fields, it doesn't hurt.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1932 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
@Danny.
Thanks.Your trick to invert the data statement worked.


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 207 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Styling issue with TYPE=DATA

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.