hide chart if error


https://www.nevron.com/Forum/Topic8884.aspx
Print Topic | Close Window

By Philip Saxegaard - 9 Years Ago
Hi
I have a chart that will show this message: An error occured during the web part rendering. The error was: Object cannot be cast from DBNull to other types.
I recieve this error message bacause there are no data in my list, and that is by design. Is it possible to make an IF statement in the value field in the pivot that chacks if the calculation returns an error or not?

I want to display a title that says exactly what went wrong for my users. The reason I want to avoid the default error message, is because the chart stops automatically refreshing in the interval.

Greetings
Philip
By Nevron Support - 9 Years Ago
Hi,

Currently you cannot handle the case when an expression in the pivot throws an error. You can however try to first remove the error by writing an expression that handles it, and then hide the chart area based on the input values. The same goes for an error title - you can make it conditionally visible, if the data that needs to be displayed is not expected.