title: Report design needs solving crystal reports
body: <p>I am trying to generate a report that generates results as follows:</p>
  
  <p>If there are results of YES and NO for Picture Exist against a common Pattern Number as shown in Image Number 1, I would like the results to be generated.</p>
  
  <p>If there are results with only YES for Picture Exist against a common pattern number, I would like the results to not be generated.</p>
  
  <p>Id there are results with only NO for Picture Exists against a common pattern number, I would like the results to not be generated.</p>
  
  <p>Pattern number is TOOL_Tools.Tooling_Number
  Picture Exists is Max of @Picture Exist, this is a formula field as shown in Image Number 2.</p>
  
  <hr>
  
  <p>Image Number 1</p>
  
  <p><img src="https://i.stack.imgur.com/KgtUP.jpg" alt="enter image description here"></p>
  
  <hr>
  
  <p>Image Number 2 </p>
  
  <p><img src="https://i.stack.imgur.com/cL8dr.jpg" alt="enter image description here"></p>
  
  <hr>
  
  <p>Image Number 3</p>
  
  <p>This is how the tables are linked.
  <img src="https://i.stack.imgur.com/1YNYh.jpg" alt="enter image description here"></p>
  
  <hr>
  
  <p>If you need any more information please ask</p>