This is a migrated thread and some comments may be shown as answers.

Aggregate function to show X of Y items

6 Answers 62 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Halász Levente
Top achievements
Rank 1
Halász Levente asked on 15 Jun 2010, 01:37 PM
Dear Telerik Team,

Let's say I have a list of bills issued by a company. Grouping by issue date I'll have two groups, the ones issued no later than 3 days ago and the rest of them.

I'd like to show in the group header how many items each group is containing in the following format X bills of Y.

Now the problem isn't calculating X but accessing the total number of rows from the custom aggregate "function".

Is it possible to do this?

Do you plan to expose some kind of interface/class which I could use to do custom grouping, so I don't have to create extra columns in the data object to do custom grouping like the above mentioned one.

Regards,

Levente

6 Answers, 1 is accepted

Sort by
0
Pavel Pavlov
Telerik team
answered on 15 Jun 2010, 02:15 PM
Hi Halász Levente,

It is not a straightforward task. We need to place a custom control in the Group footer to display the total count as the aggregate function has no access to all items  of RadGridView

This approach is demonstrated in the sample attached.


Best wishes,
Pavel Pavlov
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.
0
Halász Levente
Top achievements
Rank 1
answered on 18 Jun 2010, 02:33 PM
Thank you for your reply, tough it was my mistake not formulating my question the right way. What I really need is calculating the percentage, something like this 25 of 100 (25%).

Is there a way to bind a property to the result of AggregateFunction?

Regards,

Levente




0
Pavel Pavlov
Telerik team
answered on 18 Jun 2010, 03:17 PM
Hello Halász Levente,

I believe we can think of some solution. Where does the property (the one you need to bind) reside ?
Let me know the expected behavior and I will modify the example according to your requirements - with the property bound to whatever you need.

Sincerely yours,
Pavel Pavlov
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
0
Halász Levente
Top achievements
Rank 1
answered on 21 Jun 2010, 11:12 AM
I don't really want to bind it, it was just an idea. What I need is display the percentage of the record count in the group against total record count. So if there 25 record in my group and there are 100 records in the whole list then I'd like to display 25%.
0
Accepted
Pavel Pavlov
Telerik team
answered on 21 Jun 2010, 04:50 PM
Hi Halász Levente,

Please find the modified sample attached.

Kind regards,
Pavel Pavlov
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
0
Halász Levente
Top achievements
Rank 1
answered on 22 Jun 2010, 02:20 PM
That is it. Thank you!
Tags
GridView
Asked by
Halász Levente
Top achievements
Rank 1
Answers by
Pavel Pavlov
Telerik team
Halász Levente
Top achievements
Rank 1
Share this question
or