Sample Header Ad - 728x90

Split record data in ssrs

0 votes
1 answer
217 views
Hi all can you please assist me, I would like to split my records into different year and month see below I want figure one to be split into different categories but this must all display on one page. my current result set is like this: Date Year Date Month Instructor Num Of Members 2013 November Jones 57 2013 November Smith 40 2013 November Moreleta 55 2013 November James 65 2013 November Soodie 65 2014 January Jones 47 2014 January Smith 55 2014 January Moreleta 60 2014 January James 73 2014 January Soodie 68 2014 February Jones 48 2014 February Smith 60 2014 February Moreleta 66 2014 February James 75 2014 February Soodie 68 I want them to be split like the one below. Can any of you assist me in doing this. Date Year Date Month Instructor Num Of Members 2013 November Jones 57 2013 November Smith 40 2013 November Moreleta 55 2013 November James 65 2013 November Soodie 65 2014 January Jones 47 2014 January Smith 55 2014 January Moreleta 60 2014 January James 73 2014 January Soodie 68 2014 February Jones 48 2014 February Smith 60 2014 February Moreleta 66 2014 February James 75 2014 February Soodie 68
Asked by Kay (1 rep)
Jul 11, 2014, 11:51 AM
Last activity: Jul 11, 2014, 12:28 PM