Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Select Expert: How to filter specific words? Post Reply Post New Topic
Author Message
netchie
Newbie
Newbie


Joined: 14 Jun 2013
Online Status: Offline
Posts: 4
Quote netchie Replybullet Topic: Select Expert: How to filter specific words?
    Posted: 16 Feb 2016 at 12:05pm
Hi,

I am a newbie here :)

I am trying to show only some part of short description on my report using Select Expert. Can you please help me on how I can do this?

I tried to use "is like" and put "archived" but when I ran the report, it went blank. I tried a formula from Report> Selection Formulas>record and put the following but I still got a blank report.

{PR_Activity.short_description}like "archived"


Basically, I am trying to show on my report anything that has "archived" on Short Description field. I have CR v. 11

Thanks in advance,
netchie


Edited by netchie - 16 Feb 2016 at 12:25pm
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 16 Feb 2016 at 1:29pm
You need to use wildcards with the like (? for one character, * for multiple characters)
IP IP Logged
netchie
Newbie
Newbie


Joined: 14 Jun 2013
Online Status: Offline
Posts: 4
Quote netchie Replybullet Posted: 16 Feb 2016 at 1:44pm
Hi kevlray,

Thanks for checking my issue. I tried is like from Select Expert and typed *archived (this word is on my short description field) but I am still getting blank report. Basically when I clicked the formula, it shows:

{PR_Activity.short_description} like "*archived"

I also tried ?archived but still the same result. I don't know what to do anymore.

Edited by netchie - 16 Feb 2016 at 1:45pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Feb 2016 at 2:40am
as kevlray indicates the * replaces many and the ? replaces 1 character.
The way you have your select written it will only find records that end with 'archived'.
To look for the word anywhere in the string add the * to the front and back of the word

{PR_Activity.short_description} like "*archived*"

Edited by DBlank - 17 Feb 2016 at 2:40am
IP IP Logged
netchie
Newbie
Newbie


Joined: 14 Jun 2013
Online Status: Offline
Posts: 4
Quote netchie Replybullet Posted: 17 Feb 2016 at 10:58am
OMG! You guys are so good and so nice to spend time to check my report issue. Thank you so much! It worked! I can't help smiling lol.

Thanks so much kevlray and Dblank. Much appreciated :)

netchie :)

Edited by netchie - 17 Feb 2016 at 10:59am
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.031 seconds.