CODEWITHSUNDEEP
excelreporting-servicesexport
Innova
Innova

Reputation: 4971

SSRS report export to Excel: need a column in "Number" format

I'm using SSRS 2005 and I have a financial report. I would like a column to be in number format when exported to Excel.

How can I specify a column to be exported in number format?

Upvotes: 4

Views: 8054

Answers (2)

Lequoa
Lequoa

Reputation: 11

Make sure your <MarkupType>None</MarkupType> not <MarkupType>HTML</MarkupType>for the textbox in your tablix or Table.

Then change the Expression of the textbox to =CInt(Format(Fields.DumpValue.Value, "#,###.0"))

Hope it helps

Upvotes: 1

niktrs
niktrs

Reputation: 10066

For every textbox in the column that contains numeric values, select it and set the Format property to N (number)

Upvotes: 0

Related Questions