Hi Steve,

When I have run into these types of errors from crystal reports I found that the parameters where in the incorrect order of the parameter data types where incorrect for crystal reports.
Note: one nasty little change crystal decisions made when they changed from 8.0 to 8.5 was that the crystal reports automatically changed the parameter order in the report(s) if you used the designer to created the sql statement / query.
I used additional parameters in the report, which I did not need for the query.

I hope this helps,

Andy