Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: count on condition Post Reply Post New Topic
Author Message
Aarav
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 12
Quote Aarav Replybullet Topic: count on condition
    Posted: 03 Aug 2010 at 9:49am
Hi,
 
I need help on count based on condition. My reports has the tracking number and application type. I want to count total number of of tracking number where application type is new or resubmission and give the name as New Application. There is another application type Renewal which I do not want to add with the others.
 
 
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 03 Aug 2010 at 10:23am
Running Total?  Distinct count of tracking number, calculate only when application type is new or resubmission (I think that is what you want).
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Aug 2010 at 10:26am

You have not mentioned Grouping or duplication of record numbers so I will assume neither exist.

You can use a Running Total
Name=NewApplication
Field to summarize=trackingnumber field
type of summary=distinctcount
evaluate=use a formula
table.appliactiontype in ['new',resubmission']
reset=never
place in detail to show incrimental changes and/or report footer for total
 
or create a formula field
if table.appliactiontype in ['new',resubmission'] then 1 else 0
and SUM it
 
 
oops, sorry Kevlray, was typing while you were posting Embarrassed


Edited by DBlank - 03 Aug 2010 at 10:27am
IP IP Logged
Aarav
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 12
Quote Aarav Replybullet Posted: 03 Aug 2010 at 10:41am
Actually I have a group on my report.
 
1st group is based on the line of business
2nd group is based on the Application type
 
CHP
 
New Submission     200
Renewal                  100
Resubmission          150
 
 
I want to display something like this
 
CHP
New          350
Renweal   100
Total         450
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Aug 2010 at 10:44am
create a formula field something like
if table.appliactiontype in ['new',resubmission'] then 'New' else table.appliactiontype
replace your application type group with grouping on this formula field instead


Edited by DBlank - 03 Aug 2010 at 10:44am
IP IP Logged
Aarav
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 12
Quote Aarav Replybullet Posted: 04 Aug 2010 at 3:33am
Thanks a lot.
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.031 seconds.