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

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

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