Skip to Content
0
Former Member
May 02, 2014 at 03:20 PM

Using {field} in [x,y,z]

26 Views

Hi,

In the middle of a report, suddenly something was driving me a little nuts. A new one for me.

I use {field} in [x,y,z] pretty frequently. Today I was losing data by using:

{Commission.POS_PROD_ID} in [9600-9602]

if I change to:

{Commission.POS_PROD_ID} in [9600,9601,9602]

This is trivial, but I wan to make sure this doesn't come up at a time when it's less detectable.

Is it evaluating 9600-9602 because I don't have a comma? Is there a syntax to avoid this?

Thanks!

Matt