Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by carolin8282

  1. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    I figured this out as well - I added a flag indicator in the select expert and it wasn't occurring anymore! Thanks for all your help!
  2. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    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})+"*
  3. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    omG, please disregard the last post - the ucase did it!!!!!!!!! THANK YOU SO MUCH!!!!!!!!! YOU HAVE NO IDEA HOW HAPPY I AM :)
  4. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    I also tried the ucase and it didn't work :(
  5. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    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}...
  6. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    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...
  7. carolin8282

    How to filter on keyword search in Crystal Reports 10.0

    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!!!

Part and Inventory Search

Back
Top