[SOLVED] Accordion By Row and Conditional Styling.

December 06, 2013, 06:10 PM

David Briars

This is an accordion by row report, taken from the manual, except that I've added styling on the 'State Rows'.

SET EXPANDBYROW=ON
TABLE FILE GGSALES
SUM BUDUNITS UNITS BUDDOLLARS DOLLARS
BY REGION
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF,FONT=ARIAL,$
TYPE=SUBTOTAL, BY=ST, BACKCOLOR=RGB(197 238 208), COLOR=RED,$
TYPE=TITLE, JUSTIFY=CENTER,$
ENDSTYLE
END
-EXIT

Indeed, I see the styling on the 'State Rows' when I run this.

My requirement is to style only the State Rows if the state is IL. Therefore, I add conditional styling:

SET EXPANDBYROW=ON
TABLE FILE GGSALES
SUM BUDUNITS UNITS BUDDOLLARS DOLLARS
BY REGION
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF,FONT=ARIAL,$
TYPE=SUBTOTAL, BY=ST, BACKCOLOR=RGB(197 238 208), COLOR=RED, WHEN = ST EQ 'IL',$
TYPE=TITLE, JUSTIFY=CENTER,$
ENDSTYLE
END
-EXIT

In this case, I see no styling on the 'State Rows' for Illinois.

This message has been edited. Last edited by: David Briars,

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster

December 07, 2013, 11:10 AM

Danny-SRL

But I do.
It is most probably your version.
Even this works:

  
-* File briars01.fex
SET EXPANDBYROW=ON
TABLE FILE GGSALES
SUM BUDUNITS UNITS BUDDOLLARS DOLLARS
BY REGION
BY ST
BY CATEGORY
BY PRODUCT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
GRID=OFF,FONT=ARIAL,$
TYPE=SUBTOTAL, BY=ST, BACKCOLOR=RGB(197 238 208), COLOR=RED, WHEN=ST EQ 'IL',$
TYPE=SUBTOTAL, BY=ST, BACKCOLOR=RGB(197 238 208), COLOR=RED, WHEN=ST EQ 'TX', $
TYPE=TITLE, JUSTIFY=CENTER,$,
ENDSTYLE
END