• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1042
  • Last Modified:

SSRS 2005 decision function for number values.

In a SSRS 2005 report I am comming backw ith values of 'Infinity %'  & "NaN %" - - how can I write a statement in which I can substitute these results for '0 %' instead to avoid end user confusion.

Thanks Experts!
0
Levi Martin
Asked:
Levi Martin
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
maybe...
IIF(Fields!columnname.Value="Infinity", "0", Fields!columnname.Value)
0
 
chrismcCommented:
Switch is another function for this sort of stuff, but IIf is generally more useful.
Look them up in Books Online for exact syntax.

Cheers
Chris
0
 
Levi MartinAuthor Commented:
SQL SERVER DBA - - your idea worked like a charm...ideas on how I can capture something like "Infinity" or "NaN?

Thanks!
0
 
Levi MartinAuthor Commented:
NM...OR worked just fine.

Thanks!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now