asked
Rolling Month Table in SSRS 2008
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. ![alt text][1] 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. ![alt text][2] Can somebody please guide me step by step? [1]: /storage/temp/1410-dataset1.png [2]: /storage/temp/1411-table.png
you will have to do it in ssms in the store proc,using least month and year and then for each month and year populate a table till max month and year. thats the only way i can think of doing it...
15 People are following this question.
