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.

-- 
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetdevelopment@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopment+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net

Reply via email to