SSRS 2008 Column Visibility Expression Evaluates to true, column not visible?

I have just tried the following =IIF(Fields!MyID. Value > 0, True, False) in Report Builder and it works fine. Try returning "SomeFieldValue" as an integer either at the database or dataset level.

Up vote 0 down vote favorite share g+ share fb share tw.

This is not working and it is driving me nuts. I have in the column visibility the following expression: =IIF(CInt(Fields!SomeField. Value) > 0,True,False) The value of "SomeField" is 1.

I am able to verify this by looking both at the dataset, and another column I added to the report just to see what the IIF is evaluating to. It evaluates to True. Shouldn't this make the column show?

Reporting-services ssrs-2008 link|improve this question edited Mar 30 at 12:28Jamie F4,9651313 asked Mar 28 at 0:18user961714296 62% accept rate.

I have just tried the following =IIF(Fields!MyID. Value > 0, True, False) in Report Builder and it works fine. Try returning "SomeFieldValue" as an integer either at the database or dataset level.

For instance in your dataset query, cast SomeFieldValue to an int and then in the column visibility expression try: =IIF(Fields!SomeFieldValue. Value > 0, True, False).

Thanks, I will give this a try this afternoon and see if it makes a difference. – user961714 Mar 29 at 16:09.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.