SSRS 2005 decision function for number values.

Posted on 2007-10-08
Last Modified: 2008-01-09
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!
Question by:Levi Martin
    LVL 16

    Accepted Solution

    IIF(Fields!columnname.Value="Infinity", "0", Fields!columnname.Value)
    LVL 18

    Expert Comment

    Switch is another function for this sort of stuff, but IIf is generally more useful.
    Look them up in Books Online for exact syntax.


    Author Comment

    by:Levi Martin
    SQL SERVER DBA - - your idea worked like a charm...ideas on how I can capture something like "Infinity" or "NaN?


    Author Comment

    by:Levi Martin
    NM...OR worked just fine.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now