Results 1 to 2 of 2

Thread: 12 Months Rolling table in SSRS

  1. #1
    Join Date
    Mar 2014
    Posts
    2

    Unhappy 12 Months Rolling table in SSRS

    Hi all,

    I need your help. I am trying to create rolling month table in SSRS report but I don’t know I where I am going badly. May be because of I am new learner in SSRS.

    Below is my data set & I showed how data looks in excel. I was doing this report in excel but my clients asked me to do in SSRS. I have given few excel tips for better understanding.

    DATASET1.PNG


    I need to create below table where data is rolling for 12 months. In excel I used few formulas to get data. I show in YELLOW color. I highlighted main group in Green color & sub group have white fill.

    Table.PNG

    Can somebody please guide me step by step?

  2. #2
    Join Date
    May 2014
    Posts
    2
    Hey, A rolling 12 month table can be created by incorporating a date field into your where clause of the query that generates the table.... such as:

    where date >= DATEADD(m, -12, current_timestamp)

    Very simple yet effective.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •