Count with condition

[Daniel Botero Correa]

Hello,

I'm searching how can i count with a condition, For example:

GROUP 1
       NUMBER
       1
       0
       1
       0
       0
       Total 0 = 3/ Total 1 = 2
GROUP 2
      NUMBER
       1
       1
       1
       0
       0
       Total 0 = 2/ Total 1 = 3
TOTAL GROUPS Total 0 = 5 / Total 1 = 5



Total 0 = 3 (it counts when the FIELDS.NUMBER = 0)
Total 1 = 2 (it counts when the FIELDS.NUMBER = 1)

I didn't find an example for that, I think is very simple but I don't know how to do it.

I want to do it in a group footer sections.

Thanks,
Daniel Botero Correa

[Peter]

Hi Daniel Botero Correa,

I have attached a sample solution for your task. I have used two events and a global variable to count if the expression is valid.

You will need the AdventureWorks sample database which comes with the installation of the product. Just change the connectionString accordingly and you should be able to run it.

Let me know whether the proposed solution helps.

Kind regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Daniel Botero Correa]

Hi Peter,

Thanks, yes i had done my solution like that but i wanted to do it automatically (for example with count function). So I have a question, Telerik's reports can be that automatically? the count function cannot count with conditions?

I think I'm gonna do my own function count and I will put it in my groups footer. When I do it, I will show you.

Thanks,
Daniel Botero Correa