Joined: 23 Nov 2007
Online Status: Offline
Posts: 10
Topic: use of Like Operator in selection expert Posted: 29 Jul 2008 at 4:26am
Dear All, I need to help regarding like operator. I am using a parameter field named "fab" and database field name is fabric, and using selection expert just select fabric and then like {?fab}.
fabric like {?fab}
but it doesn't work.
actually how do I convert the expression val like %'test'% into crystal report formula syntax.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 29 Jul 2008 at 2:53pm
Create formula that looks like this:
'%' + {?fab} + '%'
Use this formula in the select expert instead of your parameter. Note: you may have to change the '%' to '*' - Crystal can be funny that way sometimes....
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
