Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
SUBFOOT with ACROSS
 Login/Join
 
<kiddpete>
posted
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?
 
Report This Post
susannah
Expert
posted Hide Post
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.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
<kiddpete>
posted
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
 
Report This Post
MadamZuZu
Gold member
posted Hide Post
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
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
Kamesh
Master
posted Hide Post
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
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
MadamZuZu
Gold member
posted Hide Post
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
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders