Good Day, i am using Matrix control in the ssrs 2008 r2. My data is like as showed in the below.... BlockDesc KWHSUMBlock1 KWHSUMBlock2 KWHSUMBlock3 KWHSUMBlock4 ________________________________________________________________ Block1 2031290 0 0 0 Block2 3109700 10413340 0 0 Block3 2856850 17141100 6777033 0 Block4 4796000 28776000 23980000 99942200 Then, i need the data in this format, that i showed in the below. BlockDesc KWHSUMBlock1 KWHSUMBlock2 KWHSUMBlock3 KWHSUMBlock4 __________________________________________________________________ Block1 0 0 0 99942200 Block2 0 0 6777033 23980000 Block3 0 10413340 17141100 28776000 Block4 2031290 3109700 2856850 4796000 Please help me, thanks in advance. Kind Regards.

your question is bit confusing mate....can you explain more Dasari

Hello Dasari, I designed Matrix control report like as showned in the below. BlockDesc KWHSUMBlock1 KWHSUMBlock2 KWHSUMBlock3 KWHSUMBlock4 _________________________________________________________________________ Block1 2031290 0 0 0 Block2 3109700 10413340 0 0 Block3 2856850 17141100 6777033 0 Block4 4796000 28776000 23980000 99942200 But, my manager asked me to design in the Matrix Control ( i mean Matrix) like as shown in the below BlockDesc KWHSUMBlock1 KWHSUMBlock2 KWHSUMBlock3 KWHSUMBlock4 ______________________________________________________________________________ Block1 0 0 0 99942200 Block2 0 0 6777033 23980000 Block3 0 10413340 17141100 28776000 Block4 2031290 3109700 2856850 4796000 Kindly let me know if you still need any explanation. Many thanks.

Hi, in the row group use the ascending order sorting (A-Z)Best Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you

Hi RP, From your description, I still confuse with the expected result. For example, in your current data arrangement, the “2031290” number is decided by Block1 and KWHSUMBlock1. However, in the expected data arrangement, it is decided by Block4 and KWHSUMBlock1. Could you please post your dataset structure with sample data, and also post the expected result based on the data in dataset? Then, I will try to assist you achieve the requirement. Thanks, Bin Long

Hi, change the Column order group Z-A..-------------------------------------------------------------------------------- Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.

Hello Bin Long, Can i get your email, so that i can email you the chart that i wanted to design as it is. Thank you. Kind Regards

Hello IMaqbool, many thanks for your reply. Where can i see "Column order group" property, can you please let me know. Thanks.

Hi RP, Please post your dataset structure with sample data and the expected result to the following E-mail address, and then I will try to assist you solve this issue. E-mail: sqltnsp AT Microsoft.com (Please replace AT with @) (Note: Please begin with “Hi, Bin Long” in the body of E-mail) Thanks, Bin Long

PLease go in Column group properties and from left pane select sort ...change the sort field option Z-A-------------------------------------------------------------------------------- Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.