June 7, 2012 at 1:37 pm
hi
i want to hide label when one field valeu is null,
i am using this expression,
=iif(Fields!total.Value =NULL,true,false)
it showing error in expression,
"null is not declared"
June 7, 2012 at 3:48 pm
harri.reddy (6/7/2012)
hii want to hide label when one field valeu is null,
i am using this expression,
=iif(Fields!total.Value =NULL,true,false)
it showing error in expression,
"null is not declared"
Try
=iif(ISNOTHING(Fields!total.Value),true,false)
June 21, 2012 at 12:13 pm
it still showing label???
June 21, 2012 at 12:32 pm
hi,
i have 1 question, if i do iif(isnothing(field), false,true) it doesnt show me 1 label.
wjat i need is ,if there no values in y axis,x axis label should not come,only for that column.
and how can i test this condition for 3 column
iif(isnothing(field1),iif(isnothing(field2),iif(isnothing(field3) ,true,false)
i want when there is no value in all 3 field then my lable only for that date should no be shown.
June 22, 2012 at 2:09 am
It would be better to use the category properties and filter the categories (x axis items) where the condition is true. Hiding the label will still leave a gap.
Add a filter expression as :
=iif(isnothing(sum(Fields!A.Value)) and isnothing(sum(Fields!B.Value)) and isnothing(sum(Fields!C.Value)), "1", "0")
Filter where value = 0
This will only include the x-axis category for categories that have not a null in all fields (a,b,c).
Fitz
June 22, 2012 at 11:21 am
i tried this getting error like "
"Grouping cannot be performed",cannot compare data type of System.string and System.Int32
plz help
June 22, 2012 at 2:47 pm
Check your data type for the expression.
June 22, 2012 at 3:18 pm
got it,thanks so much
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply