title: How to select a specific record/row of data in Crystal Reports?
body: <p>I have my sql database Views available to my report, but sometimes they return multiple values, for example I have one that shows me the Total Credits for a range of years.</p>
  
  <p>When I click "Browse Data.." it lets me see what bits of data are available
  Eg:</p>
  
  <pre><code>Credits
  -------
  31
  45
  460
  </code></pre>
  
  <p>But I want to select 45 (based on a customer ID)... is it possible to do this?</p>
  
  <p>EDIT: An alternative is if I can link the Customer ID from two views, but only if it's not null (as sometimes there are no records in the Credits)</p>