locked
Splitting SSrs Based on Specific Data RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User569294766 posted

    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 wantLeft is What I want and right is what I am getting and right side is what I am getting

    Tuesday, December 8, 2015 3:39 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1644755831 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 10, 2015 1:57 AM