December 21, 2011 at 1:06 pm
Hi SSRS Gurus,
I have a problem when I save an SSRS Report to Excel I get a green arrow in the top right hand corner.
I also have this problem in SSIS.
There are 3 fields out of several that have this problem,
The first Program Code was defined as VARCHAR(2) and has Values of:
02
16
20, etc.
The Second is derived from an ISNULL function and it contains all Numbers or 3 leading Characters followed by Numbers:
XYZ8066402
ABC9032405
673343
The Third Contains a Percent:
15%
14%
16%
All of the other column are fine.
Any help would be greatly appreciated.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 21, 2011 at 1:32 pm
In the following example, XYZ8066402 & ABC9032405 do not have the green arrow but 673343 does.
XYZ8066402
ABC9032405
673343
If the column starts with a character there is no problem.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 23, 2011 at 9:37 am
No ideas or hints?:crying:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 23, 2011 at 2:01 pm
I think it's jsut the way that Excel handles a variance in data type within a column. your first few rows make Excel think you have a text data type, then up pops a number type. It provides the green triangle as a warning that a potential number field is being treated as text.
December 24, 2011 at 1:01 am
Burninator (12/23/2011)
I think it's jsut the way that Excel handles a variance in data type within a column. your first few rows make Excel think you have a text data type, then up pops a number type. It provides the green triangle as a warning that a potential number field is being treated as text.
That is what happens if you load Excel from SSIS.
Currently several of the Worksheets are populated from another Worksheet and the green arrow warning does not appear.
I'm trying to find a work around to this issue.:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply