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     [SOLVED] Stylesheet issues in COLUMN=N1

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Stylesheet issues in COLUMN=N1
 Login/Join
 
Tomsweb
Master
posted
I have created a little test fex to highlight a row (record) when specific sales ranges are met.
In a normal report I might want the column titles to be BOLDED, but I can live without it.
I also want the data in column 1 to be unchanged in color or style (default is white backcolor
black font and unbolded).

My problem is when the row is colored, the data in column is also bolded, depite the fact that
I have correctly the default settings for column 1 as below:
TYPE=DATA,
COLUMN=N1,
etc.

Here is my code:
quote:

TABLE FILE CAR
PRINT
CAR
MODEL
DEALER AS 'DEALER'
RETAIL AS 'RETAIL'
SALES
COMPUTE SFLAG/A1 = IF SALES LE 5000 THEN '1'
ELSE IF SALES GT 5000 AND SALES LT 10000 THEN '2'
ELSE IF SALES GE 10000 AND SALES LT 20000 THEN '3'
ELSE IF SALES GE 20000 AND SALES LT 30000 THEN '4'
ELSE '5'; NOPRINT
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR=BLACK,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N1,
COLOR='BLACK',
STYLE=BOLD,
BACKCOLOR='WHITE',
$
TYPE=DATA,
COLOR='BLUE',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '1',
$
TYPE=DATA,
COLOR='GREEN',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '2',
$
TYPE=DATA,
COLOR='RED',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '3',
$
TYPE=DATA,
COLOR='PURPLE',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '4',
$
TYPE=DATA,
COLOR='GRAY',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '5',
$
TYPE=TITLE,
COLUMN=N1,
STYLE=NORMAL,
BACKCOLOR='WHITE',
$
ENDSTYLE
END
-RUN


Thanks!!! Big Grin

This message has been edited. Last edited by: Kerry,


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
I'm not quite sure what your question is. I'm understanding that you don't want the data to be in bold. However, you specify in all your stylesheet sections STYLE=BOLD. Take that out and you've got what you need.

If not, please clarify what you're looking for.


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
TYPE=DATA,
COLUMN=N1,
COLOR='BLACK',
STYLE=BOLD,
BACKCOLOR='WHITE',
$

As Darin states, you have STYLE=BOLD for column N1 (Country). Remove that and things should work.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tomsweb
Master
posted Hide Post
I removed the STYLE=BOLD for column N1 (CAR),
and the BOLD does not disappear. To make my point I changed the code to show GRAY with
STYLE=NORMAL for the columns in that row.

I think that what is happening is the style
settings determined by the value of WHEN=SFLAG
are overridding the (default) style of column n1.

I am trying to keep the style settings of column n1 as:
TYPE=DATA,
COLUMN=N1,
COLOR='BLACK',
BACKCOLOR='WHITE',
$

regardless of the value of SFLAG.

Thanks!


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
We may need to establish which column you're trying to style. N1 is COUNTRY not CAR.

quote:
Nn
Identifies a column by its position in the report. To determine this value, count vertical sort (BY) fields, display fields, and ROW-TOTAL fields, from left to right, including NOPRINT fields. For an example, see Identifying a Column of Data.

Pn
Identifies a column by its position in the report. To determine the value of n, count vertical sort (BY) fields, display fields, and ROW-TOTAL fields from left to right. Do not count NOPRINT fields.

Cn
Identifies a display column by its position in the report. To determine the value of n, count only display fields from left to right, including NOPRINT fields. Do not count vertical sort (BY) fields or ROW-TOTAL fields.

To select all display fields use C*.



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
I'm not sure what you're trying to do, but if you're trying to have the first two report columns NOT get styled by the conditional styling, then here's a solution.

Adding the conditional styling sometimes affects the non-conditional styling, so you have to add conditions to the non-conditional styling!

See N1 and N2 styling with WHEN=SFLAG EQ '1' and WHEN=SFLAG NE '1':

TABLE FILE CAR
PRINT
CAR
MODEL
DEALER AS 'DEALER'
RETAIL AS 'RETAIL'
SALES
COMPUTE SFLAG/A1 = IF SALES LE 5000 THEN '1'
ELSE IF SALES GT 5000 AND SALES LT 10000 THEN '2'
ELSE IF SALES GE 10000 AND SALES LT 20000 THEN '3'
ELSE IF SALES GE 20000 AND SALES LT 30000 THEN '4'
ELSE '5'; NOPRINT
BY COUNTRY
-*ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=8,
COLOR=BLACK,
BACKCOLOR='NONE',
STYLE=NORMAL,
$


TYPE=DATA,
COLUMN=N1,
COLOR='BLACK',
BACKCOLOR='WHITE',
STYLE=NORMAL,
WHEN=SFLAG EQ '1',
$

TYPE=DATA,
COLUMN=N1,
COLOR='BLACK',
BACKCOLOR='WHITE',
STYLE=NORMAL,
WHEN=SFLAG NE '1',
$

TYPE=DATA,
COLUMN=N2,
COLOR='BLACK',
BACKCOLOR='WHITE',
STYLE=NORMAL,
WHEN=SFLAG EQ '1',
$

TYPE=DATA,
COLUMN=N2,
COLOR='BLACK',
BACKCOLOR='WHITE',
STYLE=NORMAL,
WHEN=SFLAG NE '1',
$

TYPE=DATA,
COLOR='BLUE',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '1',
$
TYPE=DATA,
COLOR='GREEN',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '2',
$
TYPE=DATA,
COLOR='RED',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '3',
$
TYPE=DATA,
COLOR='PURPLE',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '4',
$
TYPE=DATA,
COLOR='GRAY',
STYLE=BOLD,
BACKCOLOR='WHITE',
WHEN=SFLAG EQ '5',
$
TYPE=TITLE,
COLUMN=N1,
STYLE=NORMAL,
BACKCOLOR='WHITE',
$
ENDSTYLE
END
-RUN


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Tomsweb
Master
posted Hide Post
Thanks Francis!

I wish I'd have thought to try that...
Thanks again!


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report 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     [SOLVED] Stylesheet issues in COLUMN=N1

Copyright © 1996-2020 Information Builders