Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] ON ACROSS SUBTOTAL FIELD crashes the run
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] ON ACROSS SUBTOTAL FIELD crashes the run
 Login/Join
 
Master
posted
I have a very simple focexec:

TABLE FILE WITH_DOCS
SUM WITH_ICN/I9C AS 'With ICN'
    WITHOUT_ICN  AS 'Without ICN'
    TOTAL AS 'Total'
ACROSS DOCS AS ''
BY WEEK_ENDING AS 'Week'
WHERE DAY_OF_WEEK EQ '6';
ON DOCS SUMMARIZE WITH_ICN
END


The ON DOCS SUMMARIZE line (second to the end) crashes the run hard. "Could not get error message" hard. If I remove the field name it runs.

Does it for sub-total, subtotal as well. I'm just looking to total one field. Any recommendations on how to proceed?

This message has been edited. Last edited by: FP Mod Chuck,



 
Posts: 931 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
What's the format of DOCS?


WebFOCUS 8206, Unix, Windows
 
Posts: 1693 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Text. A20.



 
Posts: 931 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I tried this on CAR file and couldn't reproduce. How many instances of DOCS are there? Maybe you have a very wide report. As a test can see what happens when you switch from ACROSS to BY? Does the problem go away?

  
TABLE FILE WITH_DOCS
SUM WITH_ICN/I9C AS 'With ICN'
    WITHOUT_ICN  AS 'Without ICN'
    TOTAL AS 'Total'
BY DOCS AS ''
BY WEEK_ENDING AS 'Week'
WHERE DAY_OF_WEEK EQ '6';
ON DOCS SUMMARIZE WITH_ICN
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1693 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
Just two. This is a really small report. I need the grand total and I can run with ON DOCS SUMMARIZE and get a total for all three of the fields. What I really want is

ON DOCS SUMMARIZE TOTAL

. . . but I didn't want to put the word TOTAL into the mix in the forums, as it's a word used in other places. I'm getting the same crash regardless of which column I try to specify.

Can I multi-verb this critter onto the end? I think it would need to have the same ACROSS field on it and that would stop getting me a single column.



 
Posts: 931 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Master
posted Hide Post
Works with a BY instead of an ACROSS.



 
Posts: 931 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
There is no ON for an ACROSS field...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1934 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Then perhaps it's an unofficial feature? Because "ON DOCS SUMMARIZE" in the source code above works perfectly. It's when I add a fieldname at the end that the walls come down.



 
Posts: 931 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
OI Would be inclined to change the TOTAL fieldname as it's a reserved word.

However, the following works in 8.2.05. You will still get the columns that you do not include in the SUMMARIZE.

DEFINE FILE CAR
  TOTAL/D12 = RCOST + DCOST;
END
TABLE FILE CAR
  SUM RCOST
      DCOST
      TOTAL
ACROSS COUNTRY AS ''
BY MODEL
ON COUNTRY SUMMARIZE TOTAL
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
  grid=off, $
ENDSTYLE
END
-RUN


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] ON ACROSS SUBTOTAL FIELD crashes the run

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.