Solved

# Crystal Reports: Surpression Formula

Posted on 2011-04-19
278 Views
I am trying to write aformula stating to surpress field if group {Orders.OrderNo} does not contain {OrderRouting.OperCode} = "P-Mazak".  Thanks for your help
0
Question by:bmessmore

LVL 100

Expert Comment

Try this

Add a formula to the report
Name - HasPMazak
IF {OrderRouting.OperCode} = "P-Mazak" then
1
Else
0

Suppress with

Sum({@HasPMazak},{Orders.OrderNo}) = 0

mlmcc
0

Author Comment

That gives me an error that says remaining text does not appear to be part of the formula and highlights the entire formula
0

LVL 100

Accepted Solution

What did you put in the formula.

There are 2 formulas
First one you create and name HasPMazak

IF {OrderRouting.OperCode} = "P-Mazak" then
1
Else
0

The second one is the suppression formula for the field

Sum({@HasPMazak},{Orders.OrderNo}) = 0

mlmcc
0

Author Closing Comment

That did it.  Thank you!
0

## Featured Post

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…