DEFINE FILE WF_GL_DETAIL_VIEW ADD
Debits/D15.2=IF PERIOD = &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR AND TRANSAMNT GE 0 THEN TRANSAMNT ELSE 0;
Credits/D15.2=IF PERIOD = &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR AND TRANSAMNT LT 0 THEN TRANSAMNT ELSE 0;
OPENBAL/D17.2=IF PERIOD LT &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSAMNT ELSE 0;
REF/A15=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN REFERENCENO;
COM/A15=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN COMMENT_TEXT;
QTY/D12=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSQTY ELSE 0;
TT/A2=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSTYPE;
TD/MDYY=IF PERIOD EQ &PERIOD AND FISCAL_YEAR EQ &FISCALYEAR THEN TRANSDATE;

END
TABLE FILE WF_GL_DETAIL_VIEW
SUM
'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.OPENBAL' AS 'Opening,Balance'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER' NOPRINT AS 'Ctr'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO' AS 'Account,Number'
BY 'TT'
BY 'TD' AS 'Transdate'
PRINT
'REF' AS 'Reference,Number'
'COM' AS 'Comment'
'QTY' AS 'Qty'
'Debits' AS 'Debit'
'Credits' AS 'Credit'
'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNAME' AS 'Description'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER' NOPRINT AS 'Ctr'
BY 'WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO' AS 'Account,Number'
BY 'TT'
BY 'TD' AS 'Transdate'
ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.CENTER SUBTOTAL AS '*Total For Center'

ON WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.ACCOUNTNO SUBTOTAL AS '*Total For Account'

ON TT SUBTOTAL AS '*Total For TT'
HEADING
"&DATEtMDYY <+0> &TOD"
"P C C S T R U C T U R A L S, I N C."
"Cost Center Ranges : Detail Financial Report"
"By Cost Center, Acct Number, Trans Type and Transaction Date"
"For Period &PERIOD.Period:. Fiscal Year &FISCALYEAR.Fiscal Year:."
" "
WHERE ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PERIOD LE &PERIOD ) AND ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.FISCAL_YEAR EQ &FISCALYEAR ) AND ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PLANT GE '&PLANT1.Plant GE: Plant Is 2 Digits.' ) AND ( WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW.PLANT LE '&PLANT2.Plant LE: Plant Is 2 Digits.' );
ON TABLE SET PAGE-NUM ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='COURIER',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=5,
JUSTIFY=CENTER,
$
TYPE=PAGENUM,
JUSTIFY=RIGHT,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=0.805556,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=0.680556,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=0.916667,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=1.180556,
$
TYPE=REPORT,
COLUMN=N12,
SQUEEZE=1.402778,
$
TYPE=REPORT,
COLUMN=N15,
SQUEEZE=1.180556,
$
TYPE=REPORT,
COLUMN=N14,
SQUEEZE=1.388889,
$
TYPE=REPORT,
COLUMN=N13,
SQUEEZE=1.000000,
$
TYPE=REPORT,
COLUMN=N11,
SQUEEZE=1.680556,
$
TYPE=REPORT,
COLUMN=N10,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=1.180556,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=1.180556,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=OFF,
$
ENDSTYLE
END

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

I know this isn't the answer you're looking for, but I try to never use column notation (or whatever it's called) in a style-sheet. I specify the name of the column, WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW instead of N1. If the column is mentioned more than once in the TABLE (in a column-name NOPRINT and for example) you can specify which one you want to style by coding

TYPE=DATA, WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW(2), ...

OR

TYPE=DATA, WF_GL_DETAIL_VIEW.WF_GL_DETAIL_VIEW(*)

to style all mentions of the column.

I find this works for almost anything.

The styling generated by the GUI isn't very friendly to modification after creation. This is just my opinion.

from the WebFOCUS Manual:

Identifier Description

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.

Pn
Identifies a column by its position in the report. To determine the
value of n, count vertical sort (BY) fields, display fields, and ROWTOTAL
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*.

Bn
Identifies a vertical sort (BY) column by its position in the report. To
determine the value of n, count only vertical sort (BY) fields, including
NOPRINTs, from left to right.
To select all BY fields use B*.

field
Identifies a column by its field name.
When a field occurs more than once, use field(n) to select a particular
occurrence or field(*) to select all occurrences of the field.

ROWTOTAL
Identifies a column of row totals generated using ROW-TOTAL. When
used with ACROSS and multiple display commands, ROWTOTAL
generates multiple total columns. Use ROWTOTAL(n) to select a
particular total column. Use ROWTOTAL(field) to select the row total
column for a particular field.
Use ROWTOTAL(*) to select all row total columns in the report.

I also have written down that you can use An for across fields, but I haven't checked that.