12 Months Rolliing Table in SSRS

Question

Post reply

12 Months Rolliing Table in SSRS

akshay.kulkarni86

Old Hand

Points: 310
More actions
March 18, 2014 at 2:32 pm

#291077

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 dataset & 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.
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.
Can somebody please guide me step by step?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63503 More actions · Answer 1

Here's how to post data so people can mock up your data:

SELECT '3-31-2013' AS EOM_Date

, 'RA' AS Logs

, 'Valid' AS Reason

, 5 AS Units

UNION ALL

SELECT '3-31-2013'

, 'MA'

, 'Need to Complete'

, 7

UNION ALL

SELECT '3-31-2013'

, 'SA'

, 'WIP'

, 5

UNION ALL

SELECT '3-31-2013'

, 'JA'

, 'Valid'

, 9

UNION ALL

SELECT '3-31-2013'

, 'RA'

, 'WIP'

, 10;

What are you trying to calculate in the rolling 12 months? How do you specify the beginning or end of the 12 month period? Could you post enough data (not in a single month) to enable us to help you?

What exactly are you trying to calculate for the rolling 12 month period? If we knew that, then we would be able to better answer your question. Without understanding that, your question is difficult to answer.

akshay.kulkarni86 Old Hand Points: 310 More actions · Answer 2

Thanks for your reply. I have attached excel file for better understanding. Request you please hav look into file.

pietlinden SSC Guru Points: 63503 More actions · Answer 3

Cant read it - maybe because I only have Excel 2010. Another reason to post table definitions and inserts for sample data.

If you really need help, read this article and follow Jeff's advice:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

that way, people here can easily mock up your database (or the relevant part) and you can get tested code...