<div>
<div class="content wysiwyg-content">
I am grouping by a specific field (Transaction Number), within each group I have a specific value that should always be the same within that group. The total group count varies, I want to count how many different values of this specific string are in each group:-<br />
<br />
<b>11000012956</b> &nbsp;(The group count should be <b>1</b> as the value is the same within the group)<br />
AA12BBCC<br />
AA12BBCC<br />
AA12BBCC<br />
<b>11000012957</b> (The group count should be <b>3 </b>as the value has 3 different values in this group)<br />
DD5612BB<br />
DD56DD12<br />
12DD5611
</div>
</div>


I am grouping by a specific field (Transaction Number), within each group I have a specific value that should always be the same within that group. The total group count varies, I want to count how many different values of this specific string are in each group:-

11000012956  (The group count should be 1 as the value is the same within the group)
AA12BBCC
AA12BBCC
AA12BBCC
11000012957 (The group count should be 3 as the value has 3 different values in this group)
DD5612BB
DD56DD12
12DD5611

Count different string values in a group

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.