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!

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

Summing specific Words in Crystal

Status
Not open for further replies.

Snookless7

Technical User
Feb 18, 2010
28
0
0
US
Hello-

I have a crystal report wherein the report I have groups, each group there is a name and types of issues they have resolved from either Email, Live chat, or Telephone.

What i am trying to do per group is to count how many emails they have resolved as well as phone calls and Live Chats.....I need each of these as a separate total.

what i have tried so far id to create a formula in which is says if this = this then "1", if this = this then "2"..................that worked, however I could not get a count of how many 1's or 2's there were.

Any help would be appreciated.



Thank you.
 
I got it.....wooohooooo.
I used a running total field instead with a small expression.
If you know of an easier way...please feel free and share.
 
Running totals will work, but there are limits on what you can do with them. A normal conditional total is more flexible. See these links:


Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top