Crystal Reports SQL

1
votes
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.

http://i.stack.imgur.com/dtuhu.jpg
http://i.stack.imgur.com/r5cYg.jpg
http://i.stack.imgur.com/fPpOx.jpg

The below images show the fields in question.

http://i.stack.imgur.com/84vyK.jpg
http://i.stack.imgur.com/WffWW.jpg

Thanks,

Daniel

1
sqlcrystal-reports
shouldn't {PROD_Process.Process_Name} in [LARGE MOULDING"'"SMALL MOULDING"]) be {PROD_Process.Process_Name} in ('LARGE MOULDING', 'SMALL MOULDING') ? - Bala R
the comma was a typo, I have since edited it. Do the speech marks make a difference? - Daniel
Can you include some sample output that you are getting at the moment? - user359040
I just posted some hyperlinks showing reports and other information. If you require any other information please say as I am currently at work, thanks! - Daniel

1 Answers

1
votes

In: enter image description here

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...