Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Record Selection not like Post Reply Post New Topic
Author Message
HolyCow
Newbie
Newbie
Avatar

Joined: 18 Sep 2008
Location: United States
Online Status: Offline
Posts: 15
Quote HolyCow Replybullet Topic: Record Selection not like
     Posted: 21 Jan 2009 at 2:03pm
Is there a way to specify NOT LIKE in the record selection?  LIke if my database is full of "Home Depot" and "HOMEDEPOT" and "HOme DEpot"
can I specify:
{Customer_Record_header.Customer} NOT LIKE "Ho%"
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Jan 2009 at 2:10pm
I don't beleive you can use the LIKE function in crystal selection but you could use an instr here as in
instr({Customer_Record_header.Customer},"Ho")<>1
IP IP Logged
HolyCow
Newbie
Newbie
Avatar

Joined: 18 Sep 2008
Location: United States
Online Status: Offline
Posts: 15
Quote HolyCow Replybullet Posted: 21 Jan 2009 at 2:40pm
YOUR AWESOME, worked like a charm, THANKS!
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.