I have the following: 1/15/2012 1/20/2012 1/30/2012 2/15/2012 2/20/2012 2/28/2012 $5000.00 $5,000.00 $5,000.00 $3000.00 $3,000.00 $3,000.00 I want to merge these columns into one that says January, 2012 February, 2012 $15,000.00 $9,000.00 What expression would I use to accomplish this. Thank you

Hi There You just need to create a group with the following expression =monthname(datepart(DateInterval.Month ,Fields!Workdate.Value))+ " " + cstr(datepart(DateInterval.Year ,Fields!Workdate.Value)) and then add total to the group I am putting some screenshot for your help Many Thanks Syed Qazafi Anjum Hi There You just need to create a group with the following expression =monthname(datepart(DateInterval.Month ,Fields!Workdate.Value))+ " " + cstr(datepart(DateInterval.Year ,Fields!Workdate.Value)) And then add total to the group I am putting some screenshot for your help. If you have any questions pelase let me know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. =monthname(datepart(DateInterval.Month ,Fields!Workdate.Value))+ " " + cstr(datepart(DateInterval.Year ,Fields!Workdate.Value))