I am stuck with one of the most irritating problem of SSRS. In my chart, I am displaying all months for months with data and without data. Reason being User wants to see all the months.
now where there is no data in any month then in the legend, SSRS is by default putting Series 1(dont know why called it Series 1)
Instead it should display "Declined", "Re-Directed", "Upheld" but what I am getting is
"Series 1", "Declined", "Re-Directed", "Upheld"
https://i.sstatic.net/Jqh9U.jpg
https://i.sstatic.net/7t3WK.jpg
My problem is, User wants to see months with no data but she is not ready to see Series 1 in the legend and I have tried everything but couldn't figure out the solution.
Please help:
I found the answer to my question. I have updated my Stored Procedure. I wrote a Case Statement in Stored Procedure stating that where it's blank in the chart then show it as a 'No Data Yet' in the Legend.
https://i.sstatic.net/1ckTh.jpg
Image might explain better :)
