This is what i came up with John's suggestion. Will show the actual year in Report Builder.
If anyone has a better solution than this ginormous case statement let me...

Chris -- For some reason its giving me an illegal value date part error.

Henrico - I need the opposite of that i need to transform it to date not year.

Thanks 🙂

Thanks for your response. How can i implement this? I only have permission to view reports in a SharePoint library with the data source specified. Where should i run a...

I found a solution 🙂 I added this query under the Query Section "Select Month(Getdate()) -1 as LastMonth" which will give me the last month then selected the third option Override...

Thanks much for your replies 🙂 Used a data driven subscription with conditional query specified. Now its all good!

Awesome! Thanks for all your help!

Oh to answer your question. No there is no January or those 0 values on my Data. Now i understand it. There is no data to show thats why its...

The previous image is the preview of my report. This is my design view. Its a matrix with individual chart in each row(group - description). The chart should only show...