June 14, 2006, 12:51 PM
neurohold file using "ACROSS"
I have a question regarding the following code. When I go to create a report from the following hold file, I am only able to choose the USERID, and the TOTALS, I am not able to select the ACROSS VALUES such as Q1,Q2,etc... like they are their own columns. Am I doing this wrong? Are ACROSS values not allowed in a hold file. I can rewrite this hold file to do what I want the long way, but this would be a really easy way of doing what I want and should be allowed to. I am guessing there is a logical reason why I cannot do what I want here.
TABLE FILE TEMPHOLD
SUM
CNT.FIELD AS 'COUNT,FIELD'
BY USERID
ACROSS FIELD
WHERE FIELD EQ 'Q1' OR 'Q2' OR 'Q3' OR 'Q4' OR 'Q5' OR 'Q6' OR 'Q7' OR 'Q8';
ON TABLE SET PAGE-NUM OFF
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE HOLD AS A_TEMP FORMAT FOCUS INDEX USERID
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
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,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
WINDOWS SERVER, WEBFOCUS 7.1.1
June 14, 2006, 01:02 PM
Jim_at_LMHere's what we do with ACROSS - I hope this helps. (There's more to it - esp. in style sheet - no time now -sorry.)
ACROSS SUMRY_PRD_ID AS ''
COLUMNS &PFY AND OCT AND NOV AND DEC AND JAN AND FEB
AND MAR AND APR AND MAY AND JUN AND JUL AND AUG AND SEP AND &CFY
June 14, 2006, 01:08 PM
neuroYou the MAN!!! Thank you, that worked!!!