Crystal Reports Summaries

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

Topic: Summaries

Author	Message
brockloch Groupie Joined: 03 Oct 2010 Location: United Kingdom Online Status: Offline Posts: 76	Topic: Summaries Posted: 10 Aug 2014 at 10:20am
	I require some help please. I have a table that contains, amongst other things colours: row 1: red row 2: red row 3: green row 4: yellow row 5: orange row 6: green row 7: red etc. I need a count on how many times a colour appears more than once... the answer to the above is 2! Any help would be much appreciated. Thanks Ed
	brockloch
	IP Logged

praveeng Senior Member Joined: 11 Jul 2011 Online Status: Offline Posts: 165	Posted: 11 Aug 2014 at 7:10am
	Hi Ed, Create a group on Color database field and create a fromula as below WhilePrintingRecords; numbervar a; if Count({Color_field},{Color_field})>=2 Then a:=a+1; a; Place the above formula on Group Footer and also on Report Footer. Hide Group Header and Group Footer sections. HTH. --Praveen G
	Praveen Guntuka, praveen_guntuka@yahoo.com
	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.