Crystal Formula that evaluates a boolean field OR field containing not null value

2
votes

Is there a way to evaluate two fields to count the total number of records that meet the following criteria 

Field {NoValidAddress} = False OR Field {Email} = not null

I'm very new to Crystal so I've created a formula field so I've used the following, but this returns the total number of records in the table.

{NoValidAddresses} = false OR not (IsNull({Email})

Thank you for any help that can be given

1
crystal-reports
how many records are you retreving? and how much should be the value? - Siva

1 Answers

0
votes

You can easily count the number of records with values in the email field by using a formula similar to the following:

if not(isnull({Email})) or ({NoValidAddresses} = False) then 1 else 0

Once the formula is created, follow these steps:

  • Drag the formula onto the report as a field
  • Right click the field --> Insert --> Summary...
  • Set "Calculate this summary" to "Summary"
  • Check the "Add to all group levels" box

Adding the total to all group levels is probably not necessary, but it will show you the total at each group level so that you can determine which one you want to use and suppress/delete the rest.