use of Like Operator in selection expert
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3831
Printed Date: 02 May 2025 at 9:58pm
Topic: use of Like Operator in selection expert
Posted By: great_mamun
Subject: use of Like Operator in selection expert
Date 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 |
Replies:
Posted By: hilfy
Date 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 ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |
Posted By: great_mamun
Date 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.   Best regards, Abdullah Al Mamun ------------- Best Regards, Abdullah Al Mamun |
Posted By: CR_beginner
Date Posted: 12 Apr 2011 at 7:58pm
|
Thanks for this info
------------- CR_Beginner |
Posted By: pakaya
Date Posted: 26 Oct 2012 at 12:34am
| Maxxa, thankx vry mch.. it helped me much....♥ |