Page 1 of 1

Conditional count in group header band

Posted: Thu Sep 16, 2010 9:54 pm
by dcleyne
If I wanted to put a count in a group header band, I would usually use something like

{Count(GroupHeaderBand0)}

that gives me a count of the records inside that Group Header Band

If I wanted to do a conditional count of the records so that I only got counts for specific values what would I do?

The documentation talks about CountIf. Could I use something like:

{CountIf(GroupHeaderBand0, ???)}

Cheers,
Dan

Conditional count in group header band

Posted: Fri Sep 17, 2010 1:05 am
by Alex K.
Hello,

You can use next expression {CountIf(Band,Condition)}

for example
{CountIf(GroupHeaderBand1,Products.UnitPrice < 20)}

Thank you.

Conditional count in group header band

Posted: Mon Sep 20, 2010 12:32 am
by dcleyne
Thanks Aleksey!

Conditional count in group header band

Posted: Mon Sep 20, 2010 12:36 am
by Alex K.
Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.

Re: Conditional count in group header band

Posted: Wed Jan 18, 2017 7:05 am
by newbie
Hi Aleksey,

How to count in the group header band which has data more than 1 page?

Thank you.

Re: Conditional count in group header band

Posted: Wed Jan 18, 2017 10:44 pm
by Alex K.
Hello,

Please try to use Totals.Count() function.

Thank you.