since i have dynamic columns ,i used matrix control. My data is given below. AssessmenttypeId | SectionName | FieldName | value | PersonName | 4 | SecA | A1 | 0 | Pers1 4 | SecA | A2 | 0 | Pers1 4 | SecA | A3 | 1 | Pers1 4 | SecA | A1 | 1 | Pers2 4 | SecA | A2 | 2 | Pers2 4 | SecB | B1 | 1 | Pers1 4 | SecB | B2 | 2 | Pers1 5 | SecB | B1 | 1 | Pers2 5 | SecB | B2 | 2 | Pers2 Added Group : "Field Name" as column group "AsessmentTypeID" and "SectionName" as row group My report looks this way SecA PesrsonName | A1 | A2 | A3 | <Blank> | <Blank> | Pers1 | 0 | 0 | 1 | | | Pers2 | 1 | 2 | | | | SecB PesrsonName |<Blank> | <Blank> |<Blank>| B1 | B2 | Pers1 | | | | 1 | 2 | Pers2 | | | | 1 | 2 | Since each person may attend any section based on his choice, I am storing only the values which he attended. Now I want to remove the blank columns which are not related to those section name. Ex: SecA should have only 'A' Columns i.e A1,A2,A3..and not blank columns SecB should have only 'B' Columns i.e B1,B2,..and not blank columns How can i achieve this?