hi my report has 1 field ,ex name: it has types in that like name1 name2 name3 now i want grouping like, under name2 type ,group the report by field1. do i need to put filter ,coz my report output will be like name1 date name value ----- --------- ----------- name2 date name value ----- --------- ----------- name3 date name value ----- --------- ----------- any help?

Hi, You need to perform below setps in order to get this output. 1) Add date and value filed to dataset query, if they are not already present. 2) Drag the date and value to report designer. 3) Add a row group in groupings pane and sleect name from it Kindly revert if you want any more infor this.- Chintak (My Blog)

Hi Tsql, In your scenario, add a list control to your report can achieve your requirement. The steps below are for your reference: From the Toolbox window, drag the list control onto the design surface below the matrix.Right-click on the handle of the list, select "Tablix Properties". In the Dataset name drop-down list, select the corresponding dataset, click OK.In the Row Groups pane, right-click on Details and select "Group Properties". Click Add, and select [Nametype] in the Group On drop down list.From the Toolbox window, drag the Text-box control onto the list. From the dataset drag the Nametype field to the text-box.Drag the matrix to the list below the text-box. The report looks like below: If you have any questions, please feel free to ask. Regards, Charlie Liao

its just 1 tablix not 3

name is the filed in dataset and name1 ,name2 and name3 r values

Hi Tsql, In this case, you can add a row above the table header row, and then put the expression below to the first column of new inserted row. =Fields!name.Value The screenshots below are for your reference: If you have any questions, please feel free to ask. Regards, Charlie Liao