Number field turned out as text in Excel, SSRS

excel reporting-services report
san picture san · Mar 13, 2009 · Viewed 13.4k times · Source

In my SSRS reports one of the fields is using this expression, where the field is a number field. I want to see blank field if the value is 0.

=IIf(Fields!PERIOD02_VALUE.Value <> 0,Fields!PERIOD02_VALUE.Value ,"")

the Excel exported version is having this field considered as text not number.

Is there any other way to do this from SSRS side?

Answer

Peter S picture Peter S · Jun 4, 2010

I had this problem. Some cells would be text and others numbers - all with the same formatting string. The resolution is to multiply your cells expression by 1.000 (1 doesn't work!) - this forces SSRS to format the cell as a number. eg; (your expression here) * 1.000

Related questions

Exporting from SSRS to Excel with no headers

Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame to the …

Read More
How can I unmerge cells in ssrs when exporting to excel to try to sort

I'm exporting an SSRS Report to Excel and when the user tried to sort it for some column. They got the message "This operation requires the merged cells to be identically sized. How can I generate the report in SSRS …

Read More
Hidden column after export to excel when table has less than 4 columns (SSRS)

I faced following problem with exporting ssrs report to excel. When I create a table having 4 columns and then exporting it to excel I get the proper layout: But when I remove at least one of the column in ssrs …

Read More