Sql-server – SSRS 2008 Column Visibility Expression Evaluates to true, column not visible

reporting-servicessql serverssrs-2008

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?

Best Answer

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)

Related Solutions

Sql-server – Altering a column: null to not null

First, make all current NULL values disappear:

UPDATE [Table] SET [Column]=0 WHERE [Column] IS NULL

Then, update the table definition to disallow "NULLs":

ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL

SSRS 2005 -Set Visibility based on dataset rowcount

This appears to work in 2008 - hopefully it will help ...

I created a DataSet with one record in it. I then created a text box and put your code in the 'Hidden' property in the Visibility Properties section.

I then changed it to

=CountRows("MyDataSet") < 1

Which will return TRUE when there are no rows, which will set the control to hidden.

Best Answer

Related Solutions

Sql-server – Altering a column: null to not null

SSRS 2005 -Set Visibility based on dataset rowcount

Related Topic