Skip to Content
avatar image
Former Member

Selection criteria for crystal report

I need to select jobs that have 'F' followed by a number or an 'A'. I can get the F by using instr({Job.Job},'F') to show if there is an F in the job. But I am getting stuck when trying to pull only jobs with an F followed by a number or an 'A'.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 29, 2017 at 08:50 AM

    Try

    If isnumeric(Mid({{Job.Job,instr({Job.Job}, 'F')+1,1))

    or Mid({Job.Job},instr({Job.Job}, 'F')+1,1) = 'A'

    then 1 else 0

    replace then 1 else 0 with your Condition

    Ian

    Add comment
    10|10000 characters needed characters exceeded

    • You can replace 1 else 0 with true else false and it should work directly in your select filter.

      Wrap whole condition to brackets to combine with other conditions

      Ian