Link to home
Start Free TrialLog in
Avatar of bmessmore
bmessmoreFlag for United States of America

asked on

Crystal Report Record Selection Formula

I am trying to write a report selecting records based on the criteria that if {Job_Operation.Operation_Service} is = "Saw" then show the following work center/operation  for that job which will include other work centers then just "SAW".   For example Job 123-1 is Saw and Form so I want the report so show both.  Job 123-2 is Laser and Form so I  don't want it to show on the report at all.  Basically it is suppose to show all jobs going through the saw and what the next work center is.  Sorry this is confusing!  Thanks for you help if you were able to follow me :)
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bmessmore

ASKER

I have my group set up by job number.  I have placed the "HasSaw" formula in the group footer but formula is always giving me a zero return even if the group has "Saw" operations.
I forgot to sum it never mind. Sorry I am brain fried
This worked perfect.  Thanks!