Conditional count in group header band

[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

[Alex K.]

Hello,

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

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

Thank you.

[dcleyne]

Thanks Aleksey!

[Alex K.]

Hello,

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

Thank you.

[newbie]

Hi Aleksey,

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

Thank you.

[Alex K.]

Hello,

Please try to use Totals.Count() function.

Thank you.