title: Crystal Reports set record number in formula
body: <p>Would anyone know of a way to manually specify a record number within a formula, in Crystal Reports?</p>
  
  <p>For instance, I have a report linked to an SQL server View that sits on top of a table that contains 20 records. This view selects the fields I need and then orders by the highest value to the lowest.</p>
  
  <p>The report then pulls these records into the report in that order. What I would like to do is to be able to write a formula that can select a record based on its number.</p>
  
  <p>I know I can reference <strong>RecordNumber</strong> in a formula (i.e. If RecordNumber = 5 Then...) but this only works in the Detail section once it actually shows record number 5, and if I place a formula in the header section it just displays <strong>False</strong> as the header only shows the first record.</p>
  
  <p>I need to create a formula that sets the record number and then displays the desired value of that record number in the header (i.e. something like:</p>
  
  <p><em>Set RecordNumber = 5</em></p>
  
  <p><em>ToText ({table.value})</em></p>
  
  <p>Can anyone help or is Crystal just not that sophisticated?</p>