CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008
user961714
user961714

Reputation: 731

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

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?

Upvotes: 3

Views: 22512

Answers (2)

Ulysses
Ulysses

Reputation: 417

If you have fields that contain values and not numbers then the following should work to hide columns that have only NULL values for each row in the column.

Place this code as an expression in the Column Visbility object for each column that you want to evaluate

=IIF(Count(Fields!.Value) = Cint(0), True, False)

Upvotes: 1

Darren
Darren

Reputation: 70718

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)

Upvotes: 5

Related Questions