Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: use of Like Operator in selection expert Post Reply Post New Topic
Author Message
great_mamun
Newbie
Newbie
Avatar

Joined: 23 Nov 2007
Online Status: Offline
Posts: 10
Quote great_mamun Replybullet 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.

Thank you very much.
Abdullah Al Mamun
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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....
 
-Dell
IP IP Logged
great_mamun
Newbie
Newbie
Avatar

Joined: 23 Nov 2007
Online Status: Offline
Posts: 10
Quote great_mamun Replybullet Posted: 19 Aug 2008 at 4:30am
Thank a lot for your help?
i got the clue and advanced, and then my problem was solved.Tongue Clap
Clap
Best regards,
Abdullah Al Mamun
Best Regards,
Abdullah Al Mamun
IP IP Logged
CR_beginner
Newbie
Newbie
Avatar

Joined: 01 Dec 2010
Location: Sudan
Online Status: Offline
Posts: 3
Quote CR_beginner Replybullet Posted: 12 Apr 2011 at 7:58pm
Thanks for this info


Edited by CR_beginner - 24 Apr 2012 at 9:44pm
CR_Beginner
IP IP Logged
pakaya
Newbie
Newbie
Avatar

Joined: 26 Oct 2012
Location: Sri Lanka
Online Status: Offline
Posts: 1
Quote pakaya Replybullet Posted: 26 Oct 2012 at 12:34am
Maxxa, thankx vry mch.. it helped me much....♥
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.062 seconds.