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