I am using Crystal Reports V10. I am trying to select a single field, which is an integer, with multiple values.
The only possible way I could do a select statement is
by selecting the a single field in the Formula Editor. This is the current select statement that works:
{INVENTOR.ITEM_ID} in "180860,180960,180871"
This is the answer I get:
180860
180960
180871
6
60
960
Why this result? I am only asking for those three ID's. Now If I try to delete the quotes and add ( ), this is not acceptable by the program. Please help. What am I doing wrong?
Carlo
The only possible way I could do a select statement is
by selecting the a single field in the Formula Editor. This is the current select statement that works:
{INVENTOR.ITEM_ID} in "180860,180960,180871"
This is the answer I get:
180860
180960
180871
6
60
960
Why this result? I am only asking for those three ID's. Now If I try to delete the quotes and add ( ), this is not acceptable by the program. Please help. What am I doing wrong?
Carlo