Sunday, February 26, 2012

Export to excel number formatting problem

Hi,

when i try to export reports to excel number fileds has exported as text !!

I use SQL server with database in US codepage, Reporting Services in english version but excel with Italian codepage settings.

So i must convert the defaul decimal separator from "." to "," within the report generation. This cause that i can't use te cdbl() conversion directly in the report field.

Anyone have sugestion ?

P.S. I can't change the database and excel codepage settings

hi,

Please read this article: http://blogs.msdn.com/bimusings/archive/2007/01/11/happiness-is-automatic-sql-reporting-services-localization.aspx

I also used it.

regards,

Janos

|||

SOLVED !!!!

Thank you

No comments:

Post a Comment