Troubleshoot Charts (Report Builder and SSRS)


Applies To: SQL Server 2016

These issues can be helpful when working with charts.

System_CAPS_ICON_note.jpg Note

You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

Most chart types require numeric values along the value axis, which is typically the y-axis, in order to draw correctly. If the data type of your value field is String, the chart cannot display a numeric value, even if there are numerals in the fields. Instead, the chart displays a count of the total number of rows that contain a value in that field. To avoid this behavior, make sure that the fields that you use for value series have numeric data types, as opposed to strings that contain formatted numbers.

Charts (Report Builder and SSRS)

Community Additions