Focal Point
SUBFOOT with ACROSS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5611077331

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
susannah
kiddpete, 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>
Eeker 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
MadamZuZu
same here, when i print C6 for Canything for my across report, i get "*" instead of the value


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
August 15, 2006, 02:36 PM
Kamesh
You are getting '*' may be because of the number of characters exceed.

Try SET COUNTWIDTH=9

hope it helps,


WFConsultant

WF 8105M on Win7/Tomcat
August 15, 2006, 02:58 PM
MadamZuZu
Thanks Smiler


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode