IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    [SOLVED] BY Totals
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
I have a couple of columns of data that need to be kept as BY fields but I still need Totals on the BY fields. Is there a way to calculate the Totals off of BY field?

This message has been edited. Last edited by: kerry,
 
Posts: 2 | Registered: June 04, 2008Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
Kyle

- how about signature....
- some basic training

- Post some basic trial on the CAR database...




Frank

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

 
Posts: 1618 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
Look up COMPUTE and BY TOTAL and as Frank said, post some code.

You can search on the forum by pressing the Search button or by clicking the doc link in the upper right hand corner of this page.


Ginny
---------------------------------
Prod: WF 7.6.5 with 7.6.5 WFRS; AIX 5.2; WebSphere 6.1.0.15
Dev: WF 7.6.5 with 7.6.5 WFRS; AIX 5.2; WebSphere 6.1.0.15
Primarily self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable
 
Posts: 1515 | Location: BNSF: Fort Worth, TX | Registered: April 05, 2006Reply With QuoteEdit or Delete MessageReport This Post
Master
Posted Hide Post
Kyle,

Try:

PRINT field
BY field NOPRINT
ON fiEld SUBTOTAL


Daniel
wf 7.6/WinXP/IIS/SSA
www.wrapapp.com
www.srl.co.il

 
Posts: 594 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    [SOLVED] BY Totals

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