Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tech Hawks
Starting Member
2 Posts |
 Posted - 2009-03-31 : 06:35:21
|
Hi All,I'm new to reporting services. I'm getting problem while trying to export a report in excel format.Please see the below image. In each boxex a green mark is coming in the top left corner of the box. This green mark is need to be removed. I used the expression for that box is [=Code.roundBigNumber(Fields!targetValue.Value,Fields!FormatString.Value)]. Whereas in other report this expression is working perfectly and does not produce any green mark.Please give any suggestion.Thanks in advance. |
|
|
IceCreamWizard
Starting Member
11 Posts |
Posted - 2009-03-31 : 10:35:38
|
| The little green mark is a "feature" of Excel and not product of the output by Reporting Services. What the green mark indicates is that Excel recognizes a potential issue with the data. Hover your mouse over the green mark and it will tell you the issue. (You may need to click small down arrow that appears, I don't recall exactly.) You may then address the issue or ignore it.One common issue that Excel identifies is number values in a Text or General cell type. |
 |
|
|
|
|
|
Urgent! Problem To Export a Report in Excel Format