Skip to Content
0

Selection criteria for crystal report

Aug 28, 2017 at 09:35 PM

19

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Aug 29, 2017 at 08:50 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0