title: If then record selection with multiple conditions
body: <p>Using Crystal Reports 2011 to reference a View</p>
  
  <p>My formula written as a "formula field"</p>
  
  <pre><code>@mySelection
  
  IF {V_JOB.TASK} LIKE "*IN"
  AND {V_JOB.CLOSED} = "Y" 
  AND {V_JOB.DATE} &gt;= {?FrDate} 
  AND {V_JOB.DATE} &lt;= {?ToDate} 
  THEN {V_JOB.JOB} ELSE "FALSE"
  </code></pre>
  
  <p>My record selection written in the "Record Selection Formula"</p>
  
  <pre><code>{V_JOB.LMO} = 'L' AND
  {@mySelection}
  </code></pre>
  
  <p>This View contains several relevant fields. To make my record selection of the view, I want to display all records that are equal to string in .JOB, when string in .TASK like "*IN" and field .DATE = ?myDateRange and field .CLOSED = 'Y'</p>
  
  <p>so I wrote the equation to do exactly that, but the displayed records are row JOB only when TASK,DATE,CLOSED are true. But I have multiple rows of the same JOB where TASK,DATE,CLOSED is false that I also want to see. </p>
  
  <p>So if there are 30 records for Job A and only 1 of those records has @mySelection is "true" then I want to select ALL 30 records even if the other 29 are "false". The way it is written it only displays the 1 true record and not the other 29.</p>
  
  <p>Can anyone provide some assistance on what I'm doing wrong? Is there a "show all" command or perhaps I can save "true" JOBs in an array and then reference the array as my record selection?</p>