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     [CLOSED] output like this
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] output like this
 Login/Join
 
Member
posted
car model retail_cost
c1 m1
m2
m3
subtotal 20000

only need to print subtotal not values in column

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 3 | Registered: October 13, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
How nice for you.........



Oh, you want to have a report that only has the subtotal ?

How about this.

TABLE FILE CAR
SUM RETAIL_COST NOPRINT
BY CAR
BY MODEL
ON CAR SUBFOOT
"Total: <ST.RETAIL_COST "
END


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6072 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
hi thanksfor ur rpl. but in added to that i also need to print retail_cost column with out any values


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 3 | Registered: October 13, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Ah, this is a case where you need to fire up the grey matter.


e.g.
TABLE FILE CAR
SUM RETAIL_COST NOPRINT
COMPUTE RETAIL_COST/D7S = 0 ;
BY CAR
BY MODEL
ON CAR SUBFOOT
"Total: <ST.RETAIL_COST "
END


If you need the total to align up with the column, then have a look in the documentation for HEADALIGN for HTML or EXCEL, and POSITION for PDF.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6072 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] output like this

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