Kevin Meyer
Top achievements
Rank 1
Rank 1
Kevin Meyer
asked on 02 May 2008, 08:29 PM
I need to order groups by something other than the field used to group by. For example, assume I have a list of Customers with non-unique names. I group on Customer Id, but display Customer Name. I need to order on the customer's name, not the Id. What's the recommended approach for doing this with Q1 2008?
30 Answers, 1 is accepted
0
Hi Kevin,
The functionality you are looking for cannot currently be achieved. It requires a mechanism for setting dependencies between fields.
Grouping by more than one field will be introduced in one of our future releases:
Example:
"CustomerID, CustomerName Group by CustomerName DESC, CustomerID"
This expression currently generates two grouping levels (one for CustomerName and one sub-level for CustomerID). This, however will change to a single level of grouping, where CustomerName and CustomerID will be the same, and sorting will be done on CustomerName, then by CustomerID.
If you have any additional questions, please contact me.
Kind regards,
Evtim
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
The functionality you are looking for cannot currently be achieved. It requires a mechanism for setting dependencies between fields.
Grouping by more than one field will be introduced in one of our future releases:
Example:
"CustomerID, CustomerName Group by CustomerName DESC, CustomerID"
This expression currently generates two grouping levels (one for CustomerName and one sub-level for CustomerID). This, however will change to a single level of grouping, where CustomerName and CustomerID will be the same, and sorting will be done on CustomerName, then by CustomerID.
If you have any additional questions, please contact me.
Kind regards,
Evtim
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
tpowell
Top achievements
Rank 1
Rank 1
answered on 16 Sep 2008, 11:11 PM
We have this same issue in our application, we group by their id but want it ordered by their last name. This was originally posted back in may. Is this issue fixed in Q2?
0
erwin
Top achievements
Rank 1
Veteran
Iron
Rank 1
Veteran
Iron
answered on 17 Sep 2008, 09:30 AM
Posted that before but thought it would fit in well with the
grouping/sorting discussion:
I would like to be able to interactively sort the groups by their count()
aggregate. For example groups containing the most items first.
Erwin
grouping/sorting discussion:
I would like to be able to interactively sort the groups by their count()
aggregate. For example groups containing the most items first.
Erwin
0
Hello guys,
This feature is still not supported in the current RadGridView version, however we plan to start extending the sorting/grouping operations after the Q3 2008 release.
Currently our focus is on RadGridView virtualization, on-demand hierarchy loading, custom sorting/grouping/filtering from user code, and row templates.
Thank for the votes. We will do our best to implement this feature as soon as possible.
Regards,
Julian Benkov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
This feature is still not supported in the current RadGridView version, however we plan to start extending the sorting/grouping operations after the Q3 2008 release.
Currently our focus is on RadGridView virtualization, on-demand hierarchy loading, custom sorting/grouping/filtering from user code, and row templates.
Thank for the votes. We will do our best to implement this feature as soon as possible.
Regards,
Julian Benkov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Jim
Top achievements
Rank 1
Rank 1
answered on 21 Sep 2008, 05:51 AM
Hi guys -
Just one more vote for this functionality - desparately needed for our new app.
- Jim
Just one more vote for this functionality - desparately needed for our new app.
- Jim
0
Paul
Top achievements
Rank 1
Rank 1
answered on 05 Dec 2008, 04:27 AM
I want to know that is this function available in Q32008 now? thanks.
0
Thank you for the feedback, guys.
This functionality is in our TODO list for next our major release - Q1 2009, due at the end of February.
Sincerely yours,
Julian Benkov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
This functionality is in our TODO list for next our major release - Q1 2009, due at the end of February.
Sincerely yours,
Julian Benkov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
ppan
Top achievements
Rank 1
Rank 1
answered on 11 Feb 2009, 03:46 PM
Any news? Will this feature be available in Q1 2009 version?
0
Hello tsitas,
Thank you for your question. The feature will be introduced in Q1 2009 release. Do not hesitate to write me back if you have further questions.
Greetings,
Julian Benkov
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Thank you for your question. The feature will be introduced in Q1 2009 release. Do not hesitate to write me back if you have further questions.
Greetings,
Julian Benkov
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
tommaso
Top achievements
Rank 1
Rank 1
answered on 02 Mar 2009, 12:27 PM
Hi I just downloaded the asp.net Q1 2009 release...
I want to sort fields by the sum() of a group... You said that in Q1 it was possible to do this... how? I really need this feature otherwise I cannot use the telerik grid!!!
tommy
0
Hi tommaso,
Do you have in mind RadGrid ASP.NET AJAX in this case? I reviewed the support communication made through your account and have not found any discussion about "sorting by sum of a group". Can you please clarify what do you have in mind?
If you would like to sort by aggregated values, consider using GridCalculatedColumn as shown on this online demo:
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/columntypes/defaultcs.aspx
You can also sort inside grouped grid and display sum value results as demonstrated here:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/expressions/defaultcs.aspx
Best regards,
Sebastian
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Do you have in mind RadGrid ASP.NET AJAX in this case? I reviewed the support communication made through your account and have not found any discussion about "sorting by sum of a group". Can you please clarify what do you have in mind?
If you would like to sort by aggregated values, consider using GridCalculatedColumn as shown on this online demo:
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/columntypes/defaultcs.aspx
You can also sort inside grouped grid and display sum value results as demonstrated here:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/expressions/defaultcs.aspx
Best regards,
Sebastian
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
tommaso
Top achievements
Rank 1
Rank 1
answered on 05 Mar 2009, 10:44 AM
hi and thx for the reply but consider the example you provided:
In this example you can order by
but what I really need is to know which country has the highest totalamout so I would like to order by sum(TotalAmount) DESC...
so USA that has Group Total : $263,546.04 has to be the first and so on...
If it is not possible to do that, the grouping feature in the grid is completely useless...
tommy
0
Hi tommaso,
I can't think of a way you can do this in the group headers, however, you can sort by total values in the group footers, which is essentially the same thing. An example on how to do this can be found at the following link: Group Footers.
Best Regards,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
I can't think of a way you can do this in the group headers, however, you can sort by total values in the group footers, which is essentially the same thing. An example on how to do this can be found at the following link: Group Footers.
Best Regards,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
tommaso
Top achievements
Rank 1
Rank 1
answered on 06 Mar 2009, 01:37 PM
hi thx this is exactly what I wanna do... sorting by total value in the group footer
but how??? please help me!
tommy
0
Hello tommaso,
Excuse me for having mislead you, indeed RadGrid does not suppot such a sorting of the groups.
Best Regards,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Excuse me for having mislead you, indeed RadGrid does not suppot such a sorting of the groups.
Best Regards,
Tsvetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Julius
Top achievements
Rank 1
Rank 1
answered on 11 Apr 2013, 04:58 AM
Hi,
Just wondering if this functionality (sorting by field other than the field used to group by) is implemented by now? As I need this urgently, please reply asap.
Thanks
Just wondering if this functionality (sorting by field other than the field used to group by) is implemented by now? As I need this urgently, please reply asap.
Thanks
0
Hi Julius,
Please give us a more detailed description for which type of application and grid is your question - RadGridView for Winforms or RadGrid for ASP.NET Ajax.
I am looking forward to your reply.
All the best,
Julian Benkov
the Telerik team
Please give us a more detailed description for which type of application and grid is your question - RadGridView for Winforms or RadGrid for ASP.NET Ajax.
I am looking forward to your reply.
All the best,
Julian Benkov
the Telerik team
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more.
Check out all of the latest highlights.
0
Julius
Top achievements
Rank 1
Rank 1
answered on 15 Apr 2013, 10:47 PM
Hi Julian,
It's a web application, so I am using ASP.NET RadGrid. Basically, what I need has been described on the first thread, i.e. I need to sort the group based on other fields that I do not use to group by, e.g. if my GridGroupByField is CompanyID, I want to be able to sort the group by CompanyName.
Hope this is clear.
Thanks
It's a web application, so I am using ASP.NET RadGrid. Basically, what I need has been described on the first thread, i.e. I need to sort the group based on other fields that I do not use to group by, e.g. if my GridGroupByField is CompanyID, I want to be able to sort the group by CompanyName.
Hope this is clear.
Thanks
0
Hello Kevin,
You should add a SortExpression to the grid:
Hope it helps.
Greetings,
Tsvetoslav
the Telerik team
You should add a SortExpression to the grid:
<SortExpressions> <telerik:GridSortExpression FieldName="CompanyName" /> </SortExpressions>Hope it helps.
Greetings,
Tsvetoslav
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Julius
Top achievements
Rank 1
Rank 1
answered on 22 Apr 2013, 04:46 AM
Hi Tsvetoslav,
I have tried that and it does not work. What I want to do is to sort the grouped by rows. I tried placing that SortExpressions inside the <GroupByExpressions></GroupByExpressions> but it didn't work. Are you clear on what I'm trying to achieve? If not the first entry on this thread clarifies it.
Thanks
I have tried that and it does not work. What I want to do is to sort the grouped by rows. I tried placing that SortExpressions inside the <GroupByExpressions></GroupByExpressions> but it didn't work. Are you clear on what I'm trying to achieve? If not the first entry on this thread clarifies it.
Thanks
0
Hello Kevin,
Unfortunately your requirement is not clear to me. Could you explain in on the following example:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/expressions/defaultcs.aspx
Regards, Tsvetoslav
the Telerik team
Unfortunately your requirement is not clear to me. Could you explain in on the following example:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/expressions/defaultcs.aspx
Regards, Tsvetoslav
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Julius
Top achievements
Rank 1
Rank 1
answered on 26 Apr 2013, 01:41 AM
Hi Tsvetoslav,
I'm Julius, not Kevin, btw. The example is below:
So, basically we have a scenario where one customer places many orders, but one order can only be placed by one customer. I want to group by OrderID, but then I want to sort the grouped rows by Customer Name alphabetically. Does this help?
I'm Julius, not Kevin, btw. The example is below:
<GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields> <telerik:GridGroupByField FieldAlias="Customer" FieldName="CustomerName" SortOrder="Ascending"></telerik:GridGroupByField> <telerik:GridGroupByField FieldAlias="" FieldName="OrderID" SortOrder="None" FormatString="({0})" HeaderValueSeparator=""></telerik:GridGroupByField> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldName="OrderID" SortOrder="None"></telerik:GridGroupByField> </GroupByFields> </telerik:GridGroupByExpression> </GroupByExpressions>So, basically we have a scenario where one customer places many orders, but one order can only be placed by one customer. I want to group by OrderID, but then I want to sort the grouped rows by Customer Name alphabetically. Does this help?
0
Hi Julius,
Thanks for the explanation - just to make sure, you need to group by OrderID but then sort the whole grid on CustomerName. Unfortunately, this is not a supported scenario.
Greetings, Tsvetoslav
the Telerik team
Thanks for the explanation - just to make sure, you need to group by OrderID but then sort the whole grid on CustomerName. Unfortunately, this is not a supported scenario.
Greetings, Tsvetoslav
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Julius
Top achievements
Rank 1
Rank 1
answered on 29 Apr 2013, 11:16 PM
Hi Tsvetoslav,
Yes, I need to group by OrderID, but sort by CustomerName. Is there any chance that this feature be included in future release, as this has been requested from 4-5 years ago.
Thanks
Yes, I need to group by OrderID, but sort by CustomerName. Is there any chance that this feature be included in future release, as this has been requested from 4-5 years ago.
Thanks
0
Hi Julius,
The grid can sort the rows inside each group as it is shown in the demo, but the groups can not be sorted by other fields. A group can contain many items, so sorting the groups themselves by another field is not practically possible and not scheduled for implementation.
All the best,
Vasil
the Telerik team
The grid can sort the rows inside each group as it is shown in the demo, but the groups can not be sorted by other fields. A group can contain many items, so sorting the groups themselves by another field is not practically possible and not scheduled for implementation.
All the best,
Vasil
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
erwin
Top achievements
Rank 1
Veteran
Iron
Rank 1
Veteran
Iron
answered on 27 May 2013, 10:54 PM
I repeat my request from a couple of years ago.
In some scenarios it would be nice to be able to sort groups according to aggregates, especially number of records within the group.
Regards
Erwin
In some scenarios it would be nice to be able to sort groups according to aggregates, especially number of records within the group.
Regards
Erwin
0
Robert
Top achievements
Rank 1
Rank 1
answered on 13 Apr 2016, 06:58 PM
Yep, the management team at Telerik has responded to me that this feature would cause the need for a total re-write of their product. As one poster has said above, the lack of this feature renders grouping practically useless.
Here is a link to a competing product which does indeed understand that it is a basic feature of grouping:
Sorting Groups by Summary Values,,,
https://documentation.devexpress.com/#AspNet/CustomDocument4020
0
Hi ,
We will reconsider implementing the feature. Even if such type of data aggregation should be done on database level, to achieve best performance and support true paging capabilities.
Regards,
Vasil
Telerik
We will reconsider implementing the feature. Even if such type of data aggregation should be done on database level, to achieve best performance and support true paging capabilities.
Regards,
Vasil
Telerik
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
0
Hans
Top achievements
Rank 1
Veteran
Rank 1
Veteran
answered on 12 Sep 2018, 10:03 AM
Hi,
I have the same question as Erwin and Robert. Since the post of Vasil dates of 2016-04-18, I am wondering where Telerik now stands on this topic. I am using Telerik UI for WPF.
Regards
Hans
0
Hello Hans,
May I ask you to check out the SortGroupByAggregate RadGridView SDK example? It demonstrates how to sort groups according to the defined aggregate functions.
If that is not what you were going for, may I ask you to open a separate forum thread in the UI for WPF RadGridView section and provide some more details about your exact scenario?
Thank you in advance for your understanding.
Regards,
Vladimir Stoyanov
Progress Telerik
May I ask you to check out the SortGroupByAggregate RadGridView SDK example? It demonstrates how to sort groups according to the defined aggregate functions.
If that is not what you were going for, may I ask you to open a separate forum thread in the UI for WPF RadGridView section and provide some more details about your exact scenario?
Thank you in advance for your understanding.
Regards,
Vladimir Stoyanov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.