OK, I'm back! It's pulling in doubles for some reason. Any ideas for why this might happen? This is my code:
{uspPeregrineBCN_IT_DetailReport;1.PROBLEM_TYPE} in ["Break-Fix"] and
{uspPeregrineBCN_IT_DetailReport;1.BRIEF_DESCRIPTION} like "*"+ucase({?@keyword})+"*
I created the parameter "@keyword" and set it as a discrete value. I then used the Select Expert like this: (`table`.`briefdesc`) then selected "is like" from dropdown and selected the "@keyword". Here's the exact formula:
{uspPeregrineBCN_IT_DetailReport;1.BRIEF_DESCRIPTION} like {?@keyword}...
lbass, thank you for this suggestion. I tried doing this, but it doesn't seem to be picking anything up - I always get a report with no results (and I know there should be - the keyword shows up plenty times before I insert the parameter). The brief description is a string and I just want to...
I need help! I am using an existing report and I want to filter on a keyword that can be found in the "brief description" field. I played with many formulas with NO LUCK. I have Crystal Reports 10.0. If you can offer ANY suggestions, please do!!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.