Last post Apr 17, 2012 05:47 AM by Ashutosh Pathak
Apr 16, 2012 09:18 AM|seemadas|LINK
I have an RDLC file report with Price column to display numeric data. Database datatype is numeric(7,3). The value set as =IIF(IsNothing(Sum(Fields!Price.Value)),"-",Sum(Fields!Price.Value)). When I export the report to excel file the price column values are
stored as text. I want it to be stored as number format.
In reportViewer I have tried applying format even then it is not working. Please let me know is there any way to format this data so that it will be recognized as a number
Apr 17, 2012 05:47 AM|Ashutosh Pathak|LINK
if you are adding "-" then its obvious that it will convert as text while exporting, so first of all remove that "-" in your IIF condition and put blank or something else may be zero(0). you can also give a try if removing "-" doesnt work in your expression:
you can also have a look on below post: