CODEWITHSUNDEEP
reporting-serviceslinechartreportbuilder
thorn
thorn

Reputation: 13

Empty values issue SSRS Report Builder chart

Click for image with line chart

enter image description here

Edit for clarity: I have empty values in my series. I want SSRS to draw a direct line between the existing data points. Empty values is set to "average" and results in the stepped lines shown in the image.

I want it to look like this: Same data charted in Excel

Here is my data click here

Original post:

I have a line chart with three series in Report Builder. Two of the series have null values between points. At first I could not get the lines to show at all, but after searching, I set the empty points color to match the series color. Now it is showing the lines but they are squiggly, not straight lines between each point.

I have searched the site but am unable to find a post with this exact issue.

Upvotes: 1

Views: 455

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21703

This is a bit of an SSRS oddity. The solution is simple. You need to choose a colour for the "EmptyPoint" property of each series. I think this should be the default but there you have it..

Click on the first series, then go to the properties pane (F4 from Visual Studio or View/Properties from Report Builder).

Expand the "EmptyPoint" section and choose a colour.

Repeat for each series.

See below

enter image description here

Here's the final output.

enter image description here

For further into see the SSRS Documentation.

Add empty points to a chart in a paginated report

Upvotes: 1

Related Questions