| T O P I C R E V I E W |
| Sh1n |
Posted - 01/15/2009 : 19:51:03
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 |
| 2 L A T E S T R E P L I E S (Newest First) |
| Sh1n |
Posted - 01/16/2009 : 01:16:01
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 
|
| admin |
Posted - 01/15/2009 : 20:51:32
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 |
Report Portal
