Crystal Reports has a limit of 256 characters for the filter

 

Which means that a filter string generated by the user selections cannot exceed that limit.  This limit cannot be changed.

 

Example: "Owner IN ('OWNER1','OWNER2','OWNER3') and Lease NOT IN ('LEASE1','LEASE2','LEASE3')"

 

The example is 93 characters in length.  An owner or lease code is 10 characters each and 2 quotation marks plus commas gives us an rough estimate of an additional 12 owners or leases.


 

TO WORK AROUND:

  1. Setup hierarchy level 5 code for sale
  2. Put level code in each well
  3. In filter, choose NOT level 5 code sale instead of using NOT in list and listing all the leases