Sorru but crystal won't let you use a where clause like that.
You can do this in a few ways.
1. Varaible field that conditianlly counts (not my cup o' tea but there are a ton of explanations on how to do that.
2. If you do not have dupes create a if-then formula to return 0 / 1 and then SUM that. although I think you might want a distinctCount here.
3. Create a Running Total and use a formula for the evaluate section.
Sample.
name='NomRookieCounter'
field to evaluate={Table_A.Field_1}
Type of evaluation=Count (maybe you want a DistinctCOunt though?)
Evaluate = Use a formula
insert your condition here
{Table_A_.Field_2}="1"
Reset=Never (for a grand total in the report)
Place in Report footer for total or in details to watch an incrimental change.
Running Totals do not work in headers
IP Logged
