Does that SP even run? Shouldn't '@result' be declared somewhere first?

Excellent! Thanks everybody for your help, these are a bunch of really valuable tips. I prefer the @SQLString method, for it's flexibility, even though it can take longer to...

Hmmm.

Thanks for everyone's suggestions. I am not overly concerned about performance here - Crystal's method of querying is far less efficient than the most basic SQL filter (it normally...

Sorry, I just realized that your solution is still valid, even for the more complex filter. However, I would like to know the reason for the error (assuming someone...

Ah, great! Thanks Phil. That should work great for the simple filters. Unfortunately, I just realized that I have a couple more intricate filters to do as...