Post reply

Formatting Values

  • February 8, 2011 at 4:06 am

    #246384

    Hi,

    I have a report that gets generated from a Stored Proc.

    If I run the SP in SSMS, then it runs as normal, except that some of the results are NULL.

    When I run it in SSRS, then the NULL values are displayed as blank text boxes.

    Is there any way, via expression, to return 0 (zero) for NULL values, and the calculated values for non-NULL values.

    Thanks

  • February 8, 2011 at 4:50 am

    #1283599

    In the expression editor in SSRS you can use the Iterative If function for this . for example in the cell your value is in right click and select expression and enter something like

    =IIF(YourValue is nothing, 0, YourValue)

  • February 8, 2011 at 6:04 am

    #1283629

    Thanks Steve,

    Exactly what I was looking for. I was trying out different IIF expressions, but couldn't get one to work.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply