ERROR: The Hidden expression for the tablix ‘Table_Personnel’ uses a numeric aggregate function on data that is not numeric. Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data. (rsProcessingError)

[SoftwareRookie]

Thanks for reading this, I need help.

I'm trying to hide a table if there are no records in the dataset, but I'm getting an error.

I'm using VS2005 to build a report.  Everything works fine when I click Preview in VS2005.

Then, when I upload this to the Report Manager and run the report I get the error message:

• The Hidden expression for the tablix ‘Table_Personnel’ uses a numeric aggregate function on data that is not numeric. Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data. (rsProcessingError)

The Visible property on Table_Personnel is:  =IIF((0 = CountRows ("Personnel")),True, False)

I have no idea where to go or why it works in VS but doesn't in the Report Manager.  Any ideas, help is very much appreciated!

Thx.