Crystal Reports ow to count if data meets a criteria

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: ow to count if data meets a criteria

Author	Message
tylerp Newbie Joined: 15 Jun 2015 Online Status: Offline Posts: 2	Topic: ow to count if data meets a criteria Posted: 22 Jun 2015 at 7:28am
	I am trying to figure out how to set a rule to have a new column generate a count if the data in target column pulls in 2 or more results. The target column is contact date, and I need a list of people with 2 or more contact dates. Please help.
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 23 Jun 2015 at 4:48am
	it depends on the specifics of the data. It sounds like you are talkingabout a group condition. You might be able to group on 'person' create a distinct count of the date field at that group level create a running total (or shared variable formulas) using that group summary as the condition
	IP Logged

tylerp Newbie Joined: 15 Jun 2015 Online Status: Offline Posts: 2	Posted: 23 Jun 2015 at 11:26am
	"create a distinct count of the date field at that group level create a running total (or shared variable formulas) using that group summary as the condition" How do I do these two things? I know how to group. I know how to do a running total but not the others. Thank you very very much for your time!!!!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 24 Jun 2015 at 3:48am
	group on person insert a summary (sigma sign) select the contactdate field set it to a distinct count set it at the person gfroup level it will result something like DistinctCount ({table.ContactDate}, {table.person}) create a running total field to summarize= personid type = distinctcount evaluate = use a formula DistinctCount ({table.ContactDate}, {table.person})>1 reset = never place in report footer
	IP Logged

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