Counting when there are suppressed fields

[harrietohs]

Crystal 8.5

My report shows people who have adopted more than one animal in a particular time period. Before suppressing certain sections, it looks like:

Group: Person ID 1111
Animal ID AAAAA
Animal ID BBBBB
Sub Total: 2


Group: Person ID 2222
Animal ID CCCCC

Sub Total: 1

Group: Person ID 3333
Animal ID DDDDD
Animal ID EEEEE
Animal ID FFFFF

Sub Total: 3

I imbed suppression formulas so that the middle group - Person ID 2222 would not show on the report because he adopted only 1 animal.

My problem: How do I show the total number of people who adopted more than one animal? Apparently, because I have only suppressed, not eliminated, the single adopters, the counts I've tried include all of the records. So, instead of a grand total of 2 people who adopted more than 1 animal, it shows 3.

Any ideas will be appreciated,

Thanks,

Harriet Farmer
Ottawa Humane Society

 

[synapsevampire]

Why not posttechnical information such as your formula for suppression? It doesn't take much time and provides much more information than descriptions.

In general people use the Report->Selection Formulas->Group to suppress rows, although it can eliminate them depending upon the layout of the report and whetehr the grouping is being performed on the server.

My point is that whatever you're using to suppress should be used in the aggregate function.

One means would be to use a Running Total and in the evaluate->Use a Formula put ni the appropriate criteria.

-k

 

[lbass]

To expand on that, if you use group selection instead of suppression, you can use a running total without adding any criteria. In the group selection formula area (report->selection formula->GROUP) enter:

count({table.animalID},{table.personID}) > 1

Then for your running total, insert a running total that does a distinctcount of {table.personID}, evaluate for each record, reset never.

Place the running total in the report footer.

-LB

 

[harrietohs]

Got called away for an urgent matter - hope to get back to this report tomorrow. I will try above suggestions.

Thanks so much for your quick responses.

Harriet

 

[harrietohs]

OK - got back to report and changed it to use the Running Totals with evaluation formula - worked perfectly. Thank you.

Harriet