SSRS empty value

Posted on 2014-08-08
Last Modified: 2014-08-08
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.

Why EmptyPointValue property is not in my CustomAttributes node?

Here's another link with same content I referenced. I appreciate any help.
Question by:minglelinch
    LVL 65

    Accepted Solution

    >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)
    LVL 1

    Author Comment

    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.
    LVL 1

    Author Closing Comment

    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.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Transaction Log for database XXX is full 5 45
    Ssrs disable the home lonk 1 46
    Tracking a Database Lock - SQL 2014 10 29
    report c# 9 58
    Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now