Ether/Or type of result?

[ibn2VB]

Say I have 10 different Quality Test Sample results in my database.
Each Quality Test Sample uses the same report; the only area of the report that’s different is a group that shows selected failure data fields if data is present.
My problem is when I put a formula in; to show my report group with failures it will not show any reports that have passed.
How should I write my report formula to get an Ether/Or type of result?
Ether “Quality Test Sample reports with no failure data”
Or “Quality Test Sample reports with a failure group if data is in those given fields”

Thanks Stan

 

[CrystalRookie]

Do not use the record selection formula. Instead, define a formula field which you can use as an indicator to show ('True' or 'False') or ('Pass' or 'Fail') depending on your criteria, i.e. use your formula to determine the value of the field (You can use an If/Then/Else statement).

Group your report on this new field. Let me know if this works for you.