CODEWITHSUNDEEP
sql-serverreporting-serviceschartsreportingssrs-2012
Shinu
Shinu

Reputation: 35

SSRS Charts Legend Series 1

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:

Upvotes: 0

Views: 1963

Answers (2)

Laura Ann Truax
Laura Ann Truax

Reputation: 21

I know it's old but I found another way to hide Series1 on the chart.

  1. Click on a Series
  2. Go to the Properties pane, Appearance > (Hidden) option.
  3. Click on the Expression button (looks like Fx)
  4. Enter in the following:

=IIF(IsNothing(Fields!GROUPING_OPTION.Value)=TRUE, TRUE, FALSE)

Please see this image for an example: ScreenshotOfMyReport

Sorry- I don't have enough reputation to embed the image yet.

Upvotes: 2

Shinu
Shinu

Reputation: 35

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 :)

Upvotes: 1

Related Questions