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