Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: Totaling Based on Conditions Post Reply Post New Topic
Author Message
shortwrite
Newbie
Newbie
Avatar

Joined: 24 Mar 2011
Online Status: Offline
Posts: 5
Quote shortwrite Replybullet Topic: Totaling Based on Conditions
    Posted: 28 Mar 2011 at 10:01am
I am trying to create totals by region based on conditions. 
 
Example:
If the northeast region has a condition = "CU Approved" or "SVP Approved" then add to a count for "Approved" for that region.
 
Can anyone help?  I am not an experienced Crystal Reports developer, and the only reference I have available is the online Help.
 
Thanks!
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 11 Apr 2011 at 8:59am

You can use a Running Total. Select the field having the informatin set it to count and under evaluate use the formula. You then enter "CU Approved" or "SVP Approved" which will evaluate to true and increment the counter.  You then can place the Running Total field on the report just like you would any other data field. If a running total will not do what you need you can always create a series of formulas to do the counting . This is described in the CR Help files and I know a number of times in this forum.

Hope this help, assuming you have not already obtained the answer since it have been a couple of weeks when this was posted.
 
Regards,
 
John W.
 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 May 2011 at 10:00am
Another note, if you are using running totals with this. YOu need to put the running total within a footer (group/report).

The other option would be to use shared variables.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 26 May 2011 at 4:58am
Another option is to do a formula like this:
 
If {table.condition} = "CU Approved" or {table.condition} = "SVP Approved" then 1 else 0
 
You then do a sum on this to get your count.  Unlike running totals, this number can be placed in group headers.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.