Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Count on string Post Reply Post New Topic
Author Message
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Topic: Count on string
    Posted: 04 Nov 2016 at 1:19pm
Hello

I have a field where the user can select multiple items

Example:

Question: Disability
Choices: the field is a multiple select (they can select all 3 at the same time if needed)
    Vision
    Hearing
    Speech


The value comes back as a string below
&Vision&
or
&Vision&Hearing&Speech&
or
&Hearing&Speech&
etc..

I want to be able to count how many times each item from the list was selected

How can I do this?




Edited by sanchezgmc06 - 04 Nov 2016 at 1:24pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Nov 2016 at 2:42am
create 3 Running Totals, each with an evaluate formula using a instring or like condition.
example:
RT name = VisionCount
Field to Summarize = PK as a counter or the Question
Type of summary = Count (distinct count if duplicates need to be handled and you can use the appropriate PK)
Evaluate= use a formula
table.answer like '*vision*'
reset = never (unless you need group values)
Field to evaluate = PK or the question field
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.032 seconds.