We have a number of reports that are currently using the obsolete Chart object, which I am in process of moving to the new Graph object. I have been unable to find an equivalent on the Graph object for the EmptyValue = Approximation setting in the Chart object. Is there an equivalent setting that I've missed, or will I need to build my own approximation lines when a category has no value at a certain point?
Thanks!
6 Answers, 1 is accepted
If there is a null value for a data point, the Graph item's mechanism:
- Draws a continues line between the surrounding data points in case of LineSeries and AreaSeries;
- Leaves a blank space in case of BarSeries;
If you want to plot a bar for null values, please consider organizing the data in such manner that the calculation is included on data-retrieval.
Regards,
Stef
Telerik
Hi Stef-
I must be doing something wrong. Simple line graph, one series. DataSource is a stored proc in MS SQL Server DB. One of the data points returns a null value from the stored proc. The point is plotted in the line graph as a zero value, meaning the line goes to the x-axis (zero value) at that point, then back up to the next non-null data point. This seems to go against #1 from your reply. Is there a setting I need to change, or something else that I've missed?
Thanks for your help,
Clay
Please check the attached video illustrating the settings of a line chart, and compare the settings to yours. Also double-check the retrieved data and the actual fields' values by displaying the data in a table item for example.
In order to investigate the issue, please paste the code for generating the report and an example of the displayed data. You can also open a private support ticket and send us the requested details in a ZIP file.
Regards,
Stef
Telerik
Hi Stef-
I've recreated the problem using the Telerik Report Designer, following the steps shown in the video. I'm not sure what code you would like me to upload. The stored proc we're using returns a float from a ROUND call for the column that has the null value, and the query shows NULL where expected when running the stored proc in SQL Server Management Studio. I've attached an export from the report showing the null value plotted at zero, rather than being an approximation. I did notice that my report has an actual point plotted for the null value, where your video doesn't show a point for the null value. I'm guessing the report designer for some reason thinks the null value returned from the stored proc is more like an empty string?
Any ideas would be greatly appreciated!
Clay
Hi Stef-
I think I might have just found a resolution to my problem. We have been using Reporting Q1 2013. I just updated my dev box to Reporting Q1 2015, and the null value is plotting correctly, i.e. no data point in the graph. Is there a way to make the approximation line appear dashed, like there is in a Chart object?
Thanks!
Clay
I am glad to hear the issue is resolved.
About changing the style of the line where there is null value, it is not supported. Feel free to log a feature request for having such feature.
If you need to distinguish where the line is approximated, you can show the data point (Graph - Series - DataPointStyle - Visible), and where a point is missing means there is no value.
Regards,
Stef
Telerik