Hi Experts,

I have a crystal report in crystal report 2011 version 14.0.7.1147 RTM and back end database is MS SQL Server 2008.

The report gets the data from a stored procedure.
The problem is that I need to count a names filed and exclude certain names in that count but at the same time I need to show all names without any exclusion on the same report as well. So I don’t think so the select expert can help me here because that will totally exclude these names from the report.
So is there any way that I can show these names in the report but in the formula itself I can exclude them form the calculation.
For example:
I want to apply some kind of filer in the formula itself to exclude these values.
{Fieldname1} <> 0.00 and {Fieldname2} <> ‘No Person Designated’
I want to count and sum the rest of the rows excluding the rows in the above condition.
E.g. Count ({Fieldname3}) where {Fieldname1} <> 0.00 and {Fieldname2} <> ‘No Person Designated’

I hope it makes sense.

Thanks in advance