February 06, 2004, 02:28 PM
<kiddpete>SUBFOOT with ACROSS
I am trying to write a report like this:
TABLE FILE XYZ
SUM ALPHA
BY SEQ NOPRINT
BY ALPHA NOPRINT
SUM DOLLAR
ACROSS PERIOD AS '' ROW-TOTAL COLUMNS Q1 AND Q2 AND Q3
BY SEQ NOPRINT
ON SEQ SUBFOOT
" "
"INT PLAN
<19><30>"
" "
BY ALPHA NOPRINT
END
Where C2 is the value of DOLLAR for column Q1.
When I run this, Focus says it doesn't know what C2 and C3 are. When I remove the 'ST.', the report works for C2, but C3 is random characters.
How do I get the subtotal? How do I get DOLLARs for Q2 and Q3?
February 06, 2004, 03:24 PM
susannahkiddpete, could you try editing your post? i don't actually see a reference to C1 or to C2 ro to a 'ST.'; might help us understand your prob better.
February 06, 2004, 04:50 PM
<kiddpete> How did that happen? Yikes!
Ahhh, the character combination means something to the display software. Change the () below to <>.
TABLE FILE XYZ
SUM ALPHA
BY SEQ NOPRINT
BY ALPHA NOPRINT
SUM DOLLAR
ACROSS PERIOD AS '' ROW-TOTAL COLUMNS Q1 AND Q2 AND Q3
BY SEQ NOPRINT
ON SEQ SUBFOOT
" "
"INT PLAN <19>
(ST.C2) <30>
(ST.C3)"
" "
BY ALPHA NOPRINT
END
August 15, 2006, 11:58 AM
MadamZuZusame here, when i print C6 for Canything for my across report, i get "*" instead of the value
August 15, 2006, 02:36 PM
KameshYou are getting '*' may be because of the number of characters exceed.
Try SET COUNTWIDTH=9
hope it helps,
August 15, 2006, 02:58 PM
MadamZuZuThanks