<div>
Your example doesn't seem relevant to the question.<br />
<br />
What is wrong with using COUNT to count all the elements.<br />
<br />
Anytime I use Count or DistinctCount I try to use a field that has distinct values for each row I want counted like the record Id or key field.<br />
<br />
mlmcc
</div>


Your example doesn't seem relevant to the question.

What is wrong with using COUNT to count all the elements.

Anytime I use Count or DistinctCount I try to use a field that has distinct values for each row I want counted like the record Id or key field.

mlmcc

<div>
Thanks James... that worked. &nbsp; For future references ex.<br />
<br />
Teacher1 &nbsp;bob<br />
Teacher1 &nbsp;sam<br />
Teacher1 Sally<br />
<br />
Teacher 2 &nbsp;Sally<br />
<br />
I used distinctCount on the formula ex. &nbsp;techerN + student; &nbsp; Now &nbsp;Sally is counted twice. Once for Teacher1 and once for Teacher2. &nbsp;Before hand distinctCount cause Sally to be counted only once in the final total.
</div>


Thanks James... that worked.   For future references ex.

Teacher1  bob
Teacher1  sam
Teacher1 Sally

Teacher 2  Sally

I used distinctCount on the formula ex.  techerN + student;   Now  Sally is counted twice. Once for Teacher1 and once for Teacher2.  Before hand distinctCount cause Sally to be counted only once in the final total.

<div>
Yep. &nbsp;That's the kind of thing I was talking about.<br />
<br />
&nbsp;And you're welcome. &nbsp;Glad I could help.<br />
<br />
&nbsp;James
</div>


Yep.  That's the kind of thing I was talking about.

 And you're welcome.  Glad I could help.

 James

<div>
<div class="content wysiwyg-content">
I know there is a known issue with crosstab not totalling &nbsp;the rows correctly when you sum values using distinct. &nbsp;Is there any work around for this? &nbsp;<br />
<br />
example.<br />
<br />
total---- 5<br />
row1--- &nbsp;4<br />
&nbsp;row2-- &nbsp; 2<br />
<br />
if there is &nbsp;one value in both row1 and row2 &quot;distinct count&quot; causes the value to counted once when sumarrizing the total.<br />
<br />
Short of not using a crosstab... any workarounds for this?
</div>
</div>


I know there is a known issue with crosstab not totalling  the rows correctly when you sum values using distinct.  Is there any work around for this?  

example.

total---- 5
row1---  4
 row2--   2

if there is  one value in both row1 and row2 "distinct count" causes the value to counted once when sumarrizing the total.

Short of not using a crosstab... any workarounds for this?

crystal reports  crosstab incorrect total when summing using distinct.

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

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.