[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 991
  • Last Modified:

SSRS empty value

I have ssrs chart report (Sylinder). I want it to show null value as zero.

I followed the link the following link to make it show. I followed "To specify empty points on a chart
", steps 1 - 6 are fine. But at step 7, I did not see EmptyPointValue property in CustomAttributes node. There's no EmptyPointValue property  in CustomAttributes node. Only properties like Drawing Style, MaxPixePointWidth, PixePointDepth, PointWidth, etc. are shown in CustomAttributes node.
http://msdn.microsoft.com/en-us/library/dd207051.aspx

Why EmptyPointValue property is not in my CustomAttributes node?

Here's another link with same content I referenced. I appreciate any help.

http://www.mssqltips.com/sqlservertip/2373/how-to-handle-empty-values-in-a-line-chart-in-ssrs/
0
minglelinch
Asked:
minglelinch
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>I want it to show null value as zero.
My personal preference would be to code for this in the SP that is the data source for your report, with an --> ISNULL(some_column, 0) as some_column.

But if that's not an option, you can pull this off in SSRS by clicking on the textbox, then right-click:Expression, then entering something like -->  =IIF(IsNothing(Fields!some_column) .Value, 0 some_column)
0
 
minglelinchAuthor Commented:
I did it (ISNULL(somevalue, 0)) at the store procedure level, and also did =IIF(IsNothing(Fields!some_column) .Value, 0 some_column)  at report level. But it is still not working. I checked SP it returns 0, but the chart does not display.
0
 
minglelinchAuthor Commented:
Thanks for the post. I found the problem. It is because store procedure. No row at all for empty value. I added a row for the empty value record. Now 0 values show.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now