limit to record selection variables?

[mwhalen]

Hi there. I have a record selection on my report where type is one of a, b, c, d, ... Is there a limit to the number of variables does anyone know that you can put in the record selection?

 

[synapsevampire]

Variables shouldn't be used at all in the record selection formulas, do you mean values?

A {table.field} in ["A","B"] is not using any variables, it is a hard coded list of values compared to a field, and I doubt that you'll find a small quantity available, although the version of your software and memory will certainly change this.

If you have that many, a not({table.value} in ["X","Y","Z"]) might be simpler to code, or use a like operator.

If you post:

Crystal version
Database/connectivity
Example data
Expected output

You might discover that someone has another idea that will serve you better.

-k

 

[mwhalen]

yes I do mean values. I have too many different ones to code a like.