SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Using IsNumeric in a report template
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

harlingtonthewizard
Constraint Violating Yak Guru

Australia
350 Posts

Posted - 04/17/2013 :  03:52:47  Show Profile  Reply with Quote
I have the following in a table field which does not seem to work?

=Sum(IIF(IsNumeric(Fields!SelectToAck.Value) = 1 ,1,0))

The Fields!SelectToAck.Value is either NULL or a number. The stored procedure the data comes from has this field as int data type.

I am simply trying to count the number of fields where the value is a number.

What I am after in the end is;

=Sum(IIF(IsNumeric(Fields!SelectToAck.Value) = 1 & Fields!SelectToAck.Value < Parameters!BS8418SelectToAck98_5.Value,1,0))

Edited by - harlingtonthewizard on 04/17/2013 03:55:05

James K
Flowing Fount of Yak Knowledge

3562 Posts

Posted - 04/17/2013 :  09:00:32  Show Profile  Reply with Quote
I don't have an SSRS installation to test, but if you are trying to distinguish between NULLs and non-nulls, you could use the following:
=Sum(IIF(IsNothing(Fields!SelectToAck.Value),0,1))
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000