Hide Zeros

(0) Share

Report

Posted on by Walid Gamal

I have a column chart in Visual Studio 2010 .Some of the columns have a value of zero. Is there any way to hide the data labels for 0 values? I'd prefer it only label the columns that have values.

thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Hi,

have you tried IIF expressions?

Was this reply helpful? Yes No
Walid Gamal on at

Like (0)

Report

I tried this

=iif(Fields!culcQty.Value<>0,false,true)

but didn't work

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

can you try with count or sum or max functions as your values might be aggregating in chart

=IIf(count(fields!culcQty.Value) = 0, false, true)

=IIf(sum(fields!culcQty.Value) = 0, false, true)

=IIf(max(fields!culcQty.Value) = 0, false, true)

Was this reply helpful? Yes No
Walid Gamal on at

Like (0)

Report

I tried one by one in the visability

but no one work

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

well that sad to hear, as system is not in our hands so it would be hard to say without enough provided description. would it be fine for you, if you can post your question on right forum which is for SSRS

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Walid,

As mentioned on your other questions, please use the correct forum. This forum is about Dynamics AX. Your questions are related to Visual Studio and SSRS development.

You seem to consequently ignore my comments on your other questions. But please stop using the wrong forum and don't duplicate your questions again and again...

Was this reply helpful? Yes No
Walid Gamal on at

Like (0)

Report

Thanks for your effort Mr : Sohaib

Was this reply helpful? Yes No