Distinct Count

[jtr9999]

I am trying to count the number of participants that my report returns. I have my fields in a group footer sorted by ssn. I suppress the section if their balance is 0. I insert a summary and do a distinct count on the ssn and place it in the Grand Total (report footer). The count I get is the total number of all the participants not just the participants the report returns. What am I doing wrong?

 

[jdemmi]

Because the summary is counting ALL the records your query is RETURNING to the report. You're SUPPRESSING records from VIEW.

You can either:

1. Change your summary to consider the same supression formula used

2. Create a running total which uses a formula to count the displayed records (uses a formula similar to your supression formula)

3. Change your report's query to select only those records needed (where balance <> 0)

-- Jason
"It's Just Ones and Zeros