Advertisement
Advertisement
- 1. chrismc 177,328
- 2. mlmcc 170,060
- 3. jgv 163,165
- 4. PFrog 117,502
- 5. tshel 81,096
- 6. rickchild 61,845
- 7. RWrigley 42,004
- 8. Yurich 40,248
- 9. mark_wills 31,350
- 10. peter57r 27,460
- 11. shorak 21,300
- 12. bdreed35 19,900
- 13. chapmandew 19,660
- 14. PedroCGD 19,450
- 15. CRXIuser... 18,944
- 16. EugeneZ 18,925
- 17. ValentinoV 17,300
- 18. mwvisa1 16,450
- 19. James0... 16,360
- 20. nmcdermaid 15,700
- 21. angelIII 15,520
- 22. gdupadhyay 14,850
- 23. welchb123 14,250
- 24. crgary_tx 12,240
- 25. wykabryan 12,225
- 1. chrismc 394,592
- 2. simon_kirk 325,252
- 3. mlmcc 323,304
- 4. PFrog 235,802
- 5. Yurich 210,317
- 6. jgv 163,165
- 7. tshel 81,096
- 8. frodoman 80,287
- 9. rickchild 61,845
- 10. RWrigley 59,804
- 11. peter57r 58,922
- 12. JestersGrind 44,855
- 13. bdreed35 44,525
- 14. Hillwaaa 37,322
- 15. mark_wills 31,350
- 16. angelIII 27,870
- 17. CRXIuser... 26,938
- 18. ABaruh 25,650
- 19. dnsvh 24,192
- 20. shorak 21,300
- 21. rhinok 20,394
- 22. chapmandew 19,660
- 23. crgary_tx 19,652
- 24. PedroCGD 19,450
- 25. EugeneZ 18,925
| 07.15.2008 at 07:58AM PDT, ID: 23566313 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Exporting SSRS report to Excel - Number stored as Text error
Asked by stelth240 in SQL Reporting, Microsoft Excel Spreadsheet Software, SQL Server 2005
Tags: Microsoft, Reporting Services, 2005 SP2, Number stored as text, SSRS Excel export
=IIf(SUM(Fields!Field1.Val
, SUM(Fields!Field1.Value) / (SUM(Fields!Field1.Value) + SUM(Fields!Field2.Value)))
I would like the data cells for those matrices to export to Excel as a number, but they are currently formatting as text with the error "Number stored as text". I've seen many examples on the internet on how to fix this error and none of the examples worked for me. The examples I found were to convert the calculation using CDec() or CDbl(), to use a format like C2, P2, etc, or to create the value as a string like =[Calculation] & "%".
Five of the 10 matrices should be formatted as a percentage and the other five as a decimal number. What I noticed with the exported sheets is that some of them are formatted correctly and other sheets are not. When I use the P2 format (Percentage with 2 decimal places), Excel formats with 3 decimal places unless the last decimal is a zero. If I use just P, it formats 2 decimals correctly. Another weird thing is that the sheets that are formatted "correctly" have the custom format:
[$-1010409]#,##0.00#% (You can see the last pound sign that causes the third non-zero decimal place)
The sheets that are not formatted correctly are set to the "General" format. All the formulas are very similar for all the sheets, so they shouldn't change I would think. I attached a JPG showing the "correct" and incorrect sheets.
Any ideas?Start Free Trial
