Crystal Reports SQL

Question

IF ({PICT_Picture.Job_Print} = True AND {PROD_Process.Process_Name} in ["LARGE MOULDING","SMALL MOULDING"]) then "YES" else "NO"

So basically this is what I want, if a box is ticked (PICT_Picture.Job_Print) and if there is either LARGE MOULDING or SMALL MOULDING selected in a drop-down box (PROD_Process.Process_Name), then show YES next to the product in a report otherwise show NO.

At the moment only YES is showing in all of the columns, regardless of having small or large moulding in the field or the box being ticked.

some of the products have images under different process routes.

https://i.sstatic.net/dtuhu.jpg
https://i.sstatic.net/r5cYg.jpg
https://i.sstatic.net/fPpOx.jpg

The below images show the fields in question.

https://i.sstatic.net/84vyK.jpg
https://i.sstatic.net/WffWW.jpg

Thanks,

Daniel

Answer 1

In:

Try changing the Exceptions For Nulls dropdown to Defaults For Nulls.

Also- if you go to Database, Show SQL Query then copy/paste and execute in management studio/query analyzer and show us the results...