Distinct Count of ONLY records that appear on a report

[jonesanne]

I need to count the number of records that appear on a report. I am using date parameters and the Select Expert that shows only those records where the SUM of the sales are zero (0). My current count formula is counting ALL records, even though they all don't appear on the report.

Here is the formual I'm using:

DistinctCount ({Expanded Sales Crosstab.AccountName})

Thanks in advance for your help!

 

[kenhamady]

Use a running total to do your distinct count.

Since your criteria is based on a total, it is applied after the totals are calculated. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com