Sunday, March 25, 2012

Alerts issue :How to solve with out getting those after exporting

i have a report with 2 fields(name,zipcode).
After exporting to excel, it generates Alerts for Zipcode Field.
some of the Zipcode field values like this (34213,23423,123123-1234,34311-1212)
In zipcode filed after exporting to excel, Iam getting alerts on 34213,23423 but not on 123123-1234.?
These alerts saying "The Number in this cell is formatted as text or preceded by apostrophe"
How can i remove alerts?
Will this be done with the help of rdl with out changing the Excel?
Can any one help on this.Even though we are exporting these as text Excel is assuming the 5 digit zip
codes should be a number.
To avoid this you will have to unset the "Number stored as text" error
checking option in Excel.
From Excel you will need to open Tools : Options : Error Checking and the
uncheck "Number stored as text"
> some of the Zipcode field values like this
(34213,23423,123123-1234,34311-1212)
> In zipcode filed after exporting to excel, Iam getting alerts on
34213,23423 but not on 123123-1234.?
> These alerts saying "The Number in this cell is formatted as text or
preceded by apostrophe"
> How can i remove alerts?
> Will this be done with the help of rdl with out changing the Excel?
> Can any one help on this.
>

No comments:

Post a Comment