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] In WF8, is there a way to display columns ACROSS without using SUM?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] In WF8, is there a way to display columns ACROSS without using SUM?
 Login/Join
 
Member
posted
Is there any way to display the REGION values, but hide DOLLARS? Basically, all I want is REGION values and no other data. I'm using WF8.

SET ACRSVRBTITL=OFF
TABLE FILE GGSALES
SUM DOLLARS AS Sales
ACROSS REGION AS ''
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END
  

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


WebFOCUS 8
WebFOCUS 7705
Windows, All Outputs
 
Posts: 19 | Registered: October 28, 2016Reply With QuoteReport This Post
Silver Member
posted Hide Post
Is this something like you are looking for?

SET ACRSVRBTITL=OFF
DEFINE FILE GGSALES
Dlrs/A1 = '';
END
TABLE FILE GGSALES
SUM Dlrs AS Sales
ACROSS REGION AS ''
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END


WF 81.5, Windows7
AS/400 Database.
All Outputs

 
Posts: 46 | Registered: November 26, 2008Reply With QuoteReport This Post
Member
posted Hide Post
Very simple solution that I'll complicate a little. Smiler

Eventually my goal is to print something out similar to below, but the problem the suggested solution creates is the empty line of Row 2.

 
SET ACRSVRBTITL=OFF
DEFINE FILE GGSALES
Dlrs/A1 = '';
END
TABLE FILE GGSALES
SUM Dlrs AS Sales
ACROSS REGION AS ''
ON TABLE PCHOLD FORMAT EXL07 OPEN NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

TABLE FILE CAR
PRINT 
COUNTRY	AS ''
CAR	AS ''
MODEL	AS ''
BODYTYPE AS ''
ON TABLE PCHOLD FORMAT EXL07 CLOSE NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END
 


WebFOCUS 8
WebFOCUS 7705
Windows, All Outputs
 
Posts: 19 | Registered: October 28, 2016Reply With QuoteReport This Post
Silver Member
posted Hide Post
This should remove the Empty Row and give you what I think you are looking for.

 SET ACRSVRBTITL=OFF
SET EMPTYREPORT=ON
DEFINE FILE GGSALES
Dlrs/A1 = '';
END
TABLE FILE GGSALES
SUM Dlrs AS ''
ACROSS REGION AS ''
WHERE TOTAL Dlrs NE ''
ON TABLE PCHOLD FORMAT EXL07 OPEN NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

TABLE FILE CAR
PRINT 
COUNTRY	AS ''
CAR	AS ''
MODEL	AS ''
BODYTYPE AS ''
ON TABLE PCHOLD FORMAT EXL07 CLOSE NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END
 


WF 81.5, Windows7
AS/400 Database.
All Outputs

 
Posts: 46 | Registered: November 26, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] In WF8, is there a way to display columns ACROSS without using SUM?

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