[AlzheimerNiagara]

I know you can suppress a section if it is blank, but I'm wondering if I can suppress that section if there is only one record included in the subtotal. If you can see the attached picture, I've got group totals that only include one record and this total gets displayed in 2 different groups. I've grouped first by fund, and then by credit card type but a lot of times we'll only have say 1 visa donation per fund. I want these subtotals because we need them to show our memorial donations, but is there any way to suppress the other totals that only have 1 amount in them?

Thanks, I really don't know a whole lot about Crystal Reports (i.e. nothing) so any help is greatly appreciated!!

[DrewAllen]

Yes, it's fairly easy. All you need to do is go into Format Section (Section Expert in XI) and click on the conditional suppression for that section. Then you'll want to use a formula like

Count({ID Field}, {Group Field}) = 1 

You may want to use DistinctCount() instead of Count().

Drew

[AlzheimerNiagara]

Thanks for the quick response!

I'm trying to use the formula:

DistinctCount ({Gf.Gf_Amount}, GroupName ({Gf.Gf_Credit_Type})) = 1

and is says the running total or something can't be created. I imagine the groupname part is wrong....do I just need the part inside the {}?

I always think formulas should be written if...then...else but now I see that the then...else part is implied in the conditional formatting so that will be REALLY helpful in the future!!

[AlzheimerNiagara]

Lol....i guess I was a bit hasty in that post

Just tried

DistinctCount ({Gf.Gf_Amount}, {Gf.Gf_Credit_Type}) = 1

and it worked fine!

Thanks a lot!

[DrewAllen]

Quote:

Originally Posted by AlzheimerNiagara

Just tried

DistinctCount ({Gf.Gf_Amount}, {Gf.Gf_Credit_Type}) = 1

If you're going to use Amount, do not use DistinctCount(). Only use distinct count with fields that should be distinct like ID fields. These will be things like the Constituent ID, the Constituent System Record ID, the Gift ID, or the Gift System Record ID. In your case, you'll probably want to use one of the gift IDs.

Drew