Jump to content
Software FX Community

NULL and Zero values in data returned from database


Recommended Posts

Hi, I have attached a dataset that is being returned from a query against an SQL Server instance. It contains Null and zero values. I have also attached some chart images that appear to be corrupt due to the NULL and/or zero values. Not sure if the Funnel charts are meant to have segments showing to the left of the funnel by design (i.e. when values are missing or zero). I also receive an "Object reference not set to an instance of an object." error when I try and chart a 3D Funnel with the attached dataset. If I remove the records with NULL values the error does not occur. The TreeMap does not display the series if it contains null values. Can provide image if you require. I'm using a 120 DPI monitor on Windows 7 with Visual Studio 2010. Please let me know if you require additional information, Jonathan

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...