I have a sql server report that pulls data 17 months prior to the current date. In this report, i've created a table that displays the total count of the data received for several databases by month for the specified year(s). The Line Chart I've created displays the total count of all the databases by month and year.

In the Series Label: "Total", I enabled "Show Point"-this shows the counts for every month generated in the past and to date, however, it also displays "0" value for future months of the current year and "0" value prior the 17 month of the past year.

Is it possible to avoid the "0" values from displaying? I'd appreciate any help i can get on this. Thank you,

Aliesha

In Chart, If you are getting Values"0" and if you want to avoid from displaying,

Do one thing.

I have implemnted for it using IIF Condition .

my column name is Count.

So, IIf(Count>0,Count,"") .

by this I have avoided the 0 values.