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] Total label and total amount coming in different lines
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Total label and total amount coming in different lines
 Login/Join
 
Gold member
posted
Hi All,

I am calculating the total of one column like below.

TABLE FILE SQLOUT
PRINT
PROCESSDATE AS 'Process Date,'
DESCRIPTION AS 'Description,'
AMOUNT/D30.3 AS 'Outstanding, Shares'
COMMENTS AS 'Comment'
COMMENTDATE AS ''
ON TABLE COLUMN-TOTAL AS 'TOTAL'

but while printing on the report, TOTAL label and AMOUNT column total are coming in different rows. When i try like below then TOTAL label and TOTAL Amount are coming in one row.But i dont want to use the BY in code because no column having unique values.

TABLE FILE SQLOUT
PRINT
PROCESSDATE AS 'Process Date,'
DESCRIPTION AS 'Description,'
AMOUNT/D30.3 AS 'Outstanding, Shares'
COMMENTS AS 'Comment'
COMMENTDATE AS ''
BY PROCESSDATE AS 'Process Date,'
ON TABLE COLUMN-TOTAL AS 'TOTAL'

How to make the TOTAL label and TOTAL AMOUNT values in one row???
Thanks in advance

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


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Create a dummy field

Define file xxxx
Dummy/a2='';
End

Table file....
Print
By dummy noprint
On dummy subtotal ...

(All capitals...)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanq Frank Dutch
Its solved


Web FOCUS 7.7.03
PDF
 
Posts: 69 | Registered: May 24, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Total label and total amount coming in different lines

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