I am working on a SSRS Report where i have to group by the Customer Name.
Dataset will be something like this. Select Column1, Column2,Column2 from Customer Group by CustomerName
Expected Report Layout
Customer Name : Jim Mouse
DOB : 12/01/1970
Column1 Column2 Column3
100 DateTwo Some Entry
200 Assignment Entered works
300 Freelance Tesing
Customer Name : Sendil P
DOB : 12/01/1990
Column1 Column2 Column3
100 work hard SSRS
200 Test Zone Earth world
Issue, i am facing. By placing List, on every row of record, i am getting same customer name, DOB is repeated.
Current Output
Customer Name : Jim Mouse
DOB : 12/01/1970
Column1 Column2 Column3
100 DateTwo Some Entry
Customer Name : Jim Mouse
DOB : 12/01/1970
Column1 Column2 Column3
200 Assignment Entered works
Customer Name : Jim Mouse
DOB : 12/01/1970
Column1 Column2 Column3
300 Freelance Tesing
On following IAN steps, I attached the Image of current output.