Hi:
Our client is used to filter his legacy Crystal Reports using the condition [CustID] Not Equal 9*.
Crystal generates the correct SQL clause as Where [CustID] Not Like ‘9%’.
What would be the equivalent syntax in Report Designer’s Additional Filtering Conditions?
We don’t have an option like “Does Not Start With”
I could generate the correct filter using Parameters, but the client may want to use multiple ‘Not equal’, so it would be ideal to use the Additional Filtering Conditions.
Thanks
Best answer by Dioris Aguilar
View original