Character Data in Numeric Field


  • 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!


    A. M. Robinson

    Friday, November 01, 2013 4:38 PM


  • 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:



    Friday, November 01, 2013 5:19 PM