Crystal Reports count on condition

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: count on condition

Author	Message
Aarav Newbie Joined: 03 Aug 2010 Online Status: Offline Posts: 12	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 Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Edited by DBlank - 03 Aug 2010 at 10:27am
	IP Logged

Aarav Newbie Joined: 03 Aug 2010 Online Status: Offline Posts: 12	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

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