quote:

Originally posted by Tom Flynn:
Hello Rob M. from Target,

Welcome to the WebFOCUS world!

As a newbie, we ask that you do the following(this is my designated week to ask):

Please update your signature using the following steps:

** Update signature
1) Logon to Focal Point and go into your complete profile.
2) Scroll down the page until you see the “Signature” field.
3) Fill in the signature you want to use. Here is a sample to model:

Prod: WebFOCUS 5.2.3 on Win 2K/IIS 6/ISAPI Mode
Test: WebFOCUS 7.1 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode

4) Once all changes are made/added, scroll down to the bottom of the page and click on the Submit button.

At the top is a SEARCH tab, click on it, type in ACROSSTITLE, click GO.

Also, there are pages of examples using ACROSS styling. We try to urge new WebFOCUS folk to try out the Search feature first...

Not trying to be mean, we are all glad to have you. "YOU" finding the answer may be more beneficial than someone fixing code...

Tom

TABLE FILE EMPLOYEE
SUM 
     CNT.EMP_ID AS 'COUNT,EMP_ID'
BY COURSE_CODE
ACROSS DEPARTMENT
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=9,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=FOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=SUBHEAD,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBTOTAL,
     BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
     BORDER-TOP=HEAVY,
     BORDER-BOTTOM=HEAVY,
     BORDER-LEFT=HEAVY,
     BORDER-RIGHT=HEAVY,
     SIZE=9,
     BACKCOLOR=RGB(198 210 253),
$
TYPE=ACROSSTITLE,
     BORDER-TOP=HEAVY,
     BORDER-BOTTOM=HEAVY,
     BORDER-LEFT=HEAVY,
     BORDER-RIGHT=HEAVY,
     BACKCOLOR=RGB(17 122 238),
     STYLE=BOLD,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
ENDSTYLE
END

code better readable

	Frank
	prod: WF 7.6.5 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.5 on the same platform and databases,IE7