Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count on the column

Status
Not open for further replies.
syedmca

syedmca

Technical User
Joined
Jul 28, 2007
Messages
16
Location
IN
Hi,


I need to count the number of times AAAAA,BBBB

AAAAA
BBBBB
CCCCCC
AAAAA
BBBBB
BBBBB

count
----
AAAA= 2
BBBB=3
CCCC=1

Regards
syed
 
Sort by date Sort by votes
Just create a Running totals for each category

In RT editor select your field, in summary select count on evaluate select the formula box and for each category enter

{Filedname} = 'AAAAA'
for next
{Filedname} = 'BBBBB'

etc.

Ian
 
Upvote 0 Downvote
You could also insert a crosstab in the report footer, this will count things automatically.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tlbrown88
  • Locked
  • Question Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
944
tlbrown88
tlbrown88
milisql
  • Locked
  • Question Question
Column Header in CrossTab Report
Replies
1
Views
1K
hilfy
hilfy
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
348
Corinne30
Corinne30
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
347
Corinne30
Corinne30
J
  • Locked
  • Question Question
New page before when a detail section last on page.
Replies
1
Views
839
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top