RDLC report sorting header

Is there a way to provide headers for the results of a sort in rdlc reports. e.g. for

Names Profession

• Allan K, - Programmer
• David M, - Networker
• Irene N, - Programmer
• Moses X, - Networker
• Gerad Z,开发者_如何学运维 - Database

when i sort by Profession, i should get

Programmer

• Allan K Prog
• Irene N Prog

Networker

• David M Netw
• Moses X Netw

Database

• Gerad Z Data

NOTE: that the sorted items are under headers (Programmer, Network and Database). How can i achieve this?

I actually found the answer to my question. The data is in a table or matrix. What I did was put the matrix in a List and set the List to group by Profession and sort by Profession. Then I set the matrix rows to group by Names and sort by Profession. What happens is that the matrix repeats itsself for every Profession. As for the header, I set the top-left cell of the matrix to =Fields!Profession.Value

You Can use UserSort property for header in properties window and under that you set SortExpression property to =Fields!Profession.Value