We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
Splitting SSrs Based on Specific Data [Answered]
1 reply
Last post Dec 10, 2015 01:57 AM by Krunal Parekh
Last post Dec 10, 2015 01:57 AM by Krunal Parekh
Member
5 Points
32 Posts
Splitting SSrs Based on Specific Data
Dec 08, 2015 03:39 PM|Urvil Shah|LINK
Here is the thing I am trying to achieve it SSRS 2012 For Report generation , I want to break the table as soon the data encounters June. I wanted only one table which should split the table keeping the table header intact , I searched whole internet but I am not getting any reliable solution I can go with . Right now I am getting all the month in a single column. as You see from the image left side is what I want
and right side is what I am getting
All-Star
15252 Points
2074 Posts
Re: Splitting SSrs Based on Specific Data
Dec 10, 2015 01:57 AM|Krunal Parekh|LINK
Hello Urvil Shah,
You could manually add a column in the database according to what you what to group since you want to split by June then you could add Jan to June as group 1 and other as group 2 and then do a group by on them.
Please see: Lesson 6: Adding Grouping and Totals (Reporting Services)
With Regards,
Krunal Parekh
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.