Crystal Reports count of multi select responses

Technical Questions

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

Topic: count of multi select responses

Author	Message
bluelake Newbie Joined: 08 Jul 2010 Online Status: Offline Posts: 24	Topic: count of multi select responses Posted: 21 Nov 2011 at 5:03am
	How can I count the number of responses for each choice in a multi-select field? I want the number of A's, B's, C's, etc.
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 21 Nov 2011 at 5:20am
	I would think shared arrays. 1 to hold the value that is being counted and 1 to hold the actual count. Then use a formula to display the results HTH ps, a set of running totals would also work, if you know the values that you are looking for ahead of time. Edited by lockwelle - 21 Nov 2011 at 5:21am
	IP Logged

bluelake Newbie Joined: 08 Jul 2010 Online Status: Offline Posts: 24	Posted: 21 Nov 2011 at 5:36am
	I am a newbie to CR. Can you explain this further?
	IP Logged

kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 21 Nov 2011 at 6:57am
	you could try to create crosstab and put your {multi-select field} into Rows and {multi-select field} into Summarized Fields.
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 21 Nov 2011 at 11:48am
	i always forget about cross-tabs,and that you can do them in a group footer very nicely. it would probably be a simpler solution than the shared arrays method.
	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