IIF is a rarefied beast always likely to throw up errors, especially when
you use an = expression (and one that looks backward to me!) Have you tried
using CountRows("Personnel)<1? I've never used Report Manager. Does it
accept hidden elements dependent on the Visible property normally? In other
words if you set the table to Visible=False non-programmatically how does
it handle that?
On Monday, May 21, 2012 9:36:50 PM UTC+1, SoftwareRookie wrote:
>
> 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
