title: How to count the record number per item in SAP crystal report?
body: <p>I have a set of data in Crystal reports that looks like below:
  You can see that each item, they have corresponding quantity.</p>
  
  <pre><code>ITEM NAME                QTY         SalesOrder            
  Pure Lounge               8          SO18030097 
  Spectrum                  1          SO18030098
  Cloud                     2          SO18030099 
  </code></pre>
  
  <p>However, there are no suppressed details in the report then the line-number should be equal to RecordNumber. So the following formula I got (thanks to this suggestion) is </p>
  
  <pre><code>CStr(RecordNumber, "0") &amp; "/" &amp; CStr(Count({rpt_PackingSlip.LabelQTY}), "0")
  </code></pre>
  
  <p>and has this  output</p>
  
  <pre><code>Pure Lounge                         
  1/11                     
  SO18030097
  
  
  Spectrum                        
  1/11                     
  SO18030098  
  
  
  
  Cloud                           
  1/11             
  SO18030099      
  </code></pre>
  
  <p>Notice that it sums all the records which are in total of 11. </p>
  
  <p>But of course, my desired output is</p>
  
  <pre><code>Pure Lounge                         
  1/8 (up to 8/8)              
  SO18030097
  
  
  
  Spectrum                        
  1/1                  
  SO18030098  
  
  
  
  Cloud                           
  1/2 up to 2/2                
  SO18030099          
  </code></pre>
  
  <p>Is there something wrong with my formula? Is using RecordNumber formula the correct one? :(</p>
  
  <p>How should I do it? </p>