Search code examples
sql-serverreporting-serviceslinegraph

Incomplete or broken lines in Line Graph in SSRS

How can I complete the broken lines in Line Graph in SSRS? I set the EmptyPoint to be ZERO but the lines are not there? Any solution is highly appreciated.

Development Tool: Visual Studio 2010

Solution

  • Just set your field value to zero if it is nothing.

    enter image description here

    Set the following expression:

    =iif(isnothing(Sum(Fields!Value.Value)),0,sum(Fields!Value.Value))

    With the expression it will preview this:

    enter image description here

    Without the expression:

    enter image description here

    Let me know if this could help you.