none
Character Data in Numeric Field

    Question

  • I have an SSRS report that contains numeric data. At times, a column of a certain row may not contain data. In this event, I'd like to display an "N/A" versus displaying a zero.

    Is it remotely possible to display mixed datatypes in a numeric column?

    I'm thinking not but holding out hope there may be some way to accomplish this!

    Thanks!


    A. M. Robinson

    Friday, November 01, 2013 4:38 PM

Answers

  • Hi,

    In SSRS expressions you can mix the data types so if you have a numeric field data type you can return a string.

    To return "N/A" for a numeric field instead of zero you can write an expression as shown below:

    =iif(fields!numericfield.value=0,"N/A",fields!numericfield.value)

    HTH

    Friday, November 01, 2013 5:19 PM