Hi, one of my clients recently complained about a report that's exported into an excel file, he said that the numbers on the report are stored as text, so it can't be used in calculation (e.g SUM). And I can't seem to do anything about it. Can you please help me to solve this problem ? Thanks in advance
This might be a localization problem. In some regions, Excel recognizes formatted number as text. One work around is to define a different number formatting for your measures on SSAS side. Another work around, is to instruct your users how to convert the text to numbers. Here are few methods: http://support.microsoft.com/kb/291047
Oh, I see now, the problem is the number formatting. I've managed to solve this problem by de-activating the "Enable Server Formatting" on the option and setting it manually on the field for OWC Report. The problem doesn't happen for OLAP Reports. Thank You
Report Portal
Exporting to Excel, Number stored as text problem
Posted - 01/15/2009 : 19:51:03
