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
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:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?