Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: If criteria met then distinct count field Post Reply Post New Topic
Author Message
dibblejon
Newbie
Newbie


Joined: 05 Jan 2011
Location: United Kingdom
Online Status: Offline
Posts: 32
Quote dibblejon Replybullet Topic: If criteria met then distinct count field
    Posted: 05 Jan 2011 at 11:56pm
Hi
 
I have a problem that I need some help on.
 
Example data is at detail level:
 
Date                  OrderNo        Order Type      Sales      Name
01/12/2010       A1234           Call In              £20         Peter
01/12/2010       A1235           Call Out           £25         Tim
01/12/2011       A2234           Call In              £30         Tim
01/12/2011       B2235           Call In              £30         Peter
 
My dilemma is that I need to provide a distinct count of the OrderNo field based on the criteria if date in range and if Order Type Call In or Call Out and then summarise by each Salesmans Name
 
Any help solving would be greatly appreciated
 
Kind Regards
 
 
 
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 06 Jan 2011 at 2:43am
I would group the data by Salesman name and then create a summary field at the group level that will include all of the records that satisfy both criteria. Then just put that field somewhere in the group header or footer.

Edited by Keikoku - 06 Jan 2011 at 2:44am
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.