How many items can a filter hold?

[Gloves]

I'm trying to filter on 3,700 customers and the filter is validating, but the report does not run.  Is this too many customers?  Is there a max?  Any help would be greatly appreciated!   ;D

[Darek]

The filter would be rather on the DB side I think. Is it a simple IN filter?

[Gloves]

I do not have access to the DB so I was just utilizing a filter in a query for this task.  Yes, I use an IN statement for this action.  [Customer #] IN (111111, 222222, 333333) and etc..

[COGNOiSe administrator]

Some databases have a limit on the length of the SQL statement and in your example 3700 customers with a 10 byte length of the filed would generate a 37kB+ SQL statement.

[Gloves]

Can my DBA adjust the SQL statement limit?

[COGNOiSe administrator]

Not sure, check with them.