Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Like condition in Crystal Reports Post Reply Post New Topic
Author Message
nabilino
Newbie
Newbie
Avatar

Joined: 02 Nov 2009
Location: United States
Online Status: Offline
Posts: 25
Quote nabilino Replybullet Topic: Like condition in Crystal Reports
    Posted: 22 Jul 2010 at 8:55am
Hi everyone,

I'm trying to filter a job description to include only people with certain stings. For example:
If Employee A job title includes "Manager" then include it
Usually Job title fields would contain a long description like "AS0 HR Manager 2 Loc" I'm only interested in the "Manager" part.

I tried using like "" but that didn't work.

Regards,

Edited by nabilino - 22 Jul 2010 at 8:56am
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 22 Jul 2010 at 10:09am
you can use * sign.
 
e.g.:
uppercase({tbl.jobdesc}) like "*MANAGER*"
 
so it will read all jobdesc which contains 'Manager' with mix-case (all caps, first letter caps, all lower, mix-case).
 
note: and It will not read for 'Mgr.', 'MGR.' or 'mgr.'
 
 
 
hope it help.
 


Edited by Emir_W - 22 Jul 2010 at 10:20am
Emir W
IP IP Logged
nabilino
Newbie
Newbie
Avatar

Joined: 02 Nov 2009
Location: United States
Online Status: Offline
Posts: 25
Quote nabilino Replybullet Posted: 22 Jul 2010 at 11:14am
It helped tremendously...although I didn't use uppercase because the description would have a comma and it wasn't pulling those records.
 
Thanks 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.047 seconds.