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     Count through Report Painter
Go
New
Search
Notify
Tools
Reply
  
Count through Report Painter
 Login/Join
 
<Hardik Naik>
posted
Can anyone tell me how to count number of records through Report Painter.

What I am looking for is

Loc Number of SSN
900 1000 Records

Any help is appreciated
thanks

Hardik
 
Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi,
Select the column(SSN) in the Report Painter window.
Select the Prefix Operator pull-down list in the General toolbar.
or
Right-click the column and select Options from the shortcut menu to open the Field
Properties General tab opens.
Select an operator CNT from the drop down list.

What it does is it counts the number of occurences of SSN's by Location(900).
 
Posts: 76 | Registered: October 28, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Count through Report Painter

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