title: How to avoid the duplicate rows for total
body: <p>Using Crystal Report 7</p>
  
  <p>report</p>
  
  <pre><code>id value
  
  01 100
  02 200
  01 100
  04 200
  01 100
  </code></pre>
  
  <p>From the above report i want to avoid the duplicate rows</p>
  
  <p>Created Formula in supress like this</p>
  
  <pre><code>{id} &lt;&gt; Previous({id}) 
  </code></pre>
  
  <p>The above formula is working in crystal report which is hiding the duplicate rows, but
  in running and grant total it is showing duplicate row total also</p>
  
  <p>Running total Group by id is shwoing like this</p>
  
  <pre><code>id value
  
  01 100
  ------
     300
  
  02 200
  -------
     200
  
  04 200
  -------
     200
  </code></pre>
  
  <p>I don't want to show duplicate value total</p>
  
  <p>Expected Output</p>
  
  <p>id value</p>
  
  <pre><code>01 100
  ------
     100 'Avoided duplicate row for total 
  
  02 200
  -------
     200
  
  04 200
  -------
     200
  </code></pre>
  
  <p>How to do this in crystal report</p>
  
  <p>Need crystal report help</p>