referencing a compute in stylesheet?

I would like to reference a compute in my stylesheet by a method other than N1, something like it's field name.

TYPE=DATA, COLUMN=Sales % of Month Goal,STYLE=BOLD,$

results in a
(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 225: COLUMN=SALES % of Month

I took out the % and it didn't eliminate the error.

Any ideas? TYPE=DATA, COLUMN=SUB_GROUP_NUMBER,STYLE=ITALIC,$ works for regular old database fields, but not for my computes.

Thanks!

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Francis Mariani

Expert

posted

Hide Post

You don't really have a field called "Sales % of Month Goal" do you? Isn't that the AS name?

Though, oddly enough, this works:

TABLE FILE CAR
PRINT
CAR
COMPUTE 'Sales % of Month Goal'/D10 = SALES;
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
BORDER=1, BORDER-COLOR=SILVER, FONT='ARIAL', SIZE=8, $
TYPE=DATA, COLUMN=Sales, COLOR=RED, $
END

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, 2005

Ignored post by Francis Mariani posted

Show Post

Jason K.

Master

posted

Hide Post

Thanks Francis!

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Ignored post by Jason K. posted

Show Post

Gizmo

Gold member

posted

Hide Post

This would come down to the whole "spaces in my field name" which I would consider a very poor practice even outside of WebFOCUS.

Make the field title using 'AS' as Francis was asking.

COMPUTE SALES_PCT_MTH_GL/D10 = SALES; AS 'Sales % of Month Goal'

The stylesheet would then use SALES_PCT_MTH_GL. Until I see documentation from IBI that spaces can be used in a fieldname, I wouldn't trust it, and even then, I would still avoid it.

Windows: WF 7.6.2: SQL Server 2008 R2

Posts: 86 | Location: Chicago | Registered: August 03, 2007

Ignored post by Gizmo posted

Show Post

linus

Platinum Member

posted

Hide Post

You can also use 'field=fieldname' instead of column:
TYPE=DATA, FIELD=SALES, COLOR=RED,$

WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF

Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007

Ignored post by linus posted