how to group by one column, sort by another column

xiaoliyuan · Post by **xiaoliyuan** » Thu Jun 03, 2010 12:37 am

Hi all,
In the report, there is a datasource for a list of products. I have added a groupheader to group them by product ID, but I don't want to sort them by productID , instead I want to sort the products by product description. Anyone can help me with this?
Thanks
Ben

Post by **Jan** » Thu Jun 03, 2010 1:23 am

Hello Ben,

Please set SortDirection property of GrooupHeaderBand to None. After then add required sorting to DataBand.

Thank you.

xiaoliyuan · Post by **xiaoliyuan** » Thu Jun 03, 2010 4:49 pm

great, thanks. It works:biggrin: :biggrin: :biggrin: :biggrin: :biggrin: :biggrin:

hana · Post by **hana** » Mon Jun 20, 2011 1:00 am

I have the same problam but I dont understood your help
what do you meen " add required sorting to DataBand"?

Post by **Ivan** » Mon Jun 20, 2011 6:54 am

Hello,

hana wrote:I have the same problam but I dont understood your help
what do you meen " add required sorting to DataBand"?

Please set the Sort property of the databand to: SortBy=product_description_field, Ascending.

Thank you.

hana · Post by **hana** » Tue Jun 21, 2011 1:45 am

I want to group by ProductID
but to view the groups sorting by ProductName

I didnt mean that I wanted to sort the data of every group but to sort the groups

Post by **Andrew** » Tue Jun 21, 2011 10:20 am

Hello,

Does the only ProductName correspond to each ProductID?
Then you can group by ProductName.

Thank you.

hana · Post by **hana** » Tue Jun 21, 2011 11:36 pm

hello,

"ProductName" was just example

I want to sort by column that not correspond to each ProductID

what can I do?

Post by **Ivan** » Wed Jun 22, 2011 8:52 am

Hello,

Can you please send us a sample report template with data?

Thank you.

wprmdev · Post by **wprmdev** » Thu Feb 27, 2025 12:43 pm

I have the same problem. I have a dataset with the following structure:

SupplierId, SupplierName, ProductId, ProductName.

I need to group by SupplierId and sort by SupplierName.

And the DataBand sorts by ProductName.

Why not group by SupplierName? We can't guarantee that the name is unique. The ID is responsible for that.

This is a common situation. To me, it doesn't make sense to use a name or description instead of the ID.

Is there a solution for this?

I am using version: 2024.3.2