Counting only visible records

[Dross]

Is there any way to count the visible records on the report. I am doing alot of suppression on the report and the running totals keep adding a few extra. For instance if I see 9 records in my details section, it says 13. I have the running totals counting distinct Social Security Numbers when their status is a 1 or a 2 and grouped by the office. I've tried everything I can think of. Any ideas?

 

[rangersmom]

I suspect you've created a formula using the function
WHILEPRINTINGRECORDS;
and COUNT ing the specific field that will give you the 'correct' record count?!?! Annie Mayes
Crystal Reports Trainer

http://www.crystaluser.com

 

[Dross]

Yes I did that in the running totals as well as a regular formula field. The formula says:
whileprintingrecords;
distinctCount ({PriSSN}, {OfficeID})
The report shows 9 records for the first office id, but the running totals has 13 and the formula I have above shows 70.

 

[EricBass]

I have a similar situation that I think I just found the answer to. I have a report that displays a list of users depending on whether or not they have completed a complete set of courses. Users who have not completed the full set are being supressed. I was able to get a running total formula to give me the correct total by using the opposite formula I was using for supression.

Supress formula:
DistinctCount ({LEDef.LEDef_PK}, {@EmpName}) < 11

Running Total formula:
DistinctCount ({LEDef.LEDef_PK}, {@EmpName}) >= 11

Seems to be working.