How to design bar chart with the NULL values ?

[astha.thorecha]

I am using Jasper studio 6.1.1.I have some NULL values in the data which is causing error "category series s null " while previewing.I want to display chart with the NULL values,how can I make it possible?

[hozawa]

You'll need to convert your nulls to a 0.

[astha.thorecha]

Thanks for your solution but can you tell me how can I do this?

I am still getting error as 'category series name is null'

 

 

[carlos2015]

What is your datasource? . If you use MySQL, you can use the function IFNULL():  

"SELECT IFNULL(`MyValue`,0), FROM MyTable"

See this: http://www.w3schools.com/sql/sql_isnull.asp