asked on

How do I convert an alphanumeric field in SSRS and export to excel to avoid the number stored as text error?

I have a report with 12 columns. 11 columns export fine to excel. However, I have one of the SSRS columns that is an numeric & alphanumeric, aaa1111....etc.. When I export to excel and I open the file to view I have the green error mark in the cells of that column that are just numbers.

If I change to the expression =CDbl(Fields!your_numerical_column.Value) on the field all of my numbers only are corrected but the alphanumeric have errors. Please assist.

HainKurt

try wrapping it into " for that column

expression = '"' + ... + '"'

rhservan

ASKER

Here is the expression that I placed on that field:

=""+Fields!TrailerNumber.Value+""

This worked only on the alphanumeric but not the numeric only.

HainKurt

try

=""""+Fields!TrailerNumber.Value+""""
or
="'"+Fields!TrailerNumber.Value+"'"

rhservan

ASKER

This worked to remove the errors in excel:
=""""+Fields!TrailerNumber.Value+""""
However, in both the report and excell it shows the double quote around the values. Is there a way to hide them?
E.g. - "41244" or "JBHY3277"
Or perhaps another method. I am testing the other expression now.

rhservan

ASKER

Second expression results:
This worked to remove the errors in excel:
="'"+Fields!TrailerNumber.Value+"'"
However, in both the report and excell it shows the double quote around the values. Is there a way to hide them?
E.g. - '41244' or 'JBHY3277'

This seems to be pretty much the same issue with the single quotes. Waiting for further advisement.

HainKurt

what is your query?

rhservan

ASKER

Is there a particular part of the query you need to view?

HainKurt

the part for "aaa1111"

rhservan

ASKER

Here is the query.
EESample.txt

HainKurt

which column is creating issue?