Focal Point
Formatting Multiple Columns in the Stylesheet

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

June 30, 2008, 03:25 PM
Mighty Max
Formatting Multiple Columns in the Stylesheet
Is there syntax that combines the formatting of columns in the stylesheet?
 $
TYPE=DATA,
     COLUMN=N4,
     BACKCOLOR=( RGB(204 255 255) RGB(204 255 204) RGB(255 255 153) RGB(255 204 153) ),
$
TYPE=DATA,
     COLUMN=N5,
     BACKCOLOR=( RGB(204 255 255) RGB(204 255 204) RGB(255 255 153) RGB(255 204 153) ),
$ 


 $
-*Things I have tried
TYPE=DATA,
   -*  COLUMN=N4,N5,
   -*  COLUMN=(N4 N5),
   -*  COLUMN=(N4, N5),
     BACKCOLOR=( RGB(204 255 255) RGB(204 255 204) RGB(255 255 153) RGB(255 204 153) ),
$


I am trying to shorten up my code to make
it more readable.


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
June 30, 2008, 04:09 PM
<Jax>
Unless you want to apply the formatting to all columns in the report the column-by-column approach would be the way to go.

If you want to apply the backcolor across all columns then

TYPE=DATE,
BACKCOLOR=( RGB(204 255 255) RGB(204 255 204) RGB(255 255 153) RGB(255 204 153) ),
$
June 30, 2008, 04:57 PM
Darin Lee
As Jax mentions (and I assume he meant TYPE=DATA, not TYPE=DATE) if you don't specify a column, then by default, the style is applied to all columns. Sometimes it's shorter to do this and then single out the columns where you DON't want the style when you have numberous column that are affected.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
July 01, 2008, 03:33 PM
Mighty Max
Thanks for the information.
In a report I am working on 3 columns need to be formated one way and 2 columns another way.
I thought there might be a way to format the columns without having having to go column-by-column.
But, there isn't.


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
July 02, 2008, 05:29 AM
Danny-SRL
Max,

A bit of Dialog Manager can help:
  
-REPEAT #LAB1 FOR &I FROM 4 TO 6;
TYPE=DATA,
     COLUMN=N&I,
     BACKCOLOR=( RGB(204 255 255) RGB(204 255 204) RGB(255 255 153) RGB(255 204 153) ),
$
-#LAB



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