Force Excel Column type when exporting from SSRS

Hi all,

I have a tricky behavior here. I have a column in my report which contains alphanumeric codes. When I have a code like 17E001 and I export the report to Excel, excel kindly shows that alphanumeric code to 1+E7 and the value of the column is changed to 1700 which is defintly not what I want.

So I was wondering if there is any way to force the column types when exporting from SSRS?

Sbastien.

By the way if there is a way to force all columns to be formated as Text that will do for me as the excel reports are only used to process data using SSIS.

FOR XML EXPLICIT error: Undeclared tag ID

I am exporting xml from SQL Server 2000 using a FOR XML EXPLICIT query. It i
s
quite a big query: 56 SELECTs unions together and each one has 57 columns.
When I run it, I get the following error...
Server: Msg 6806, Level 16, State 2, Procedure DebitNotes_XmlDoc2, Line 10
Undeclared tag ID 50 is used in a FOR XML EXPLICIT query.
By the way, if I remove "FOR XML EXPLICIT", the remaining part works.
Does anyone know what that error means ?
Thanks,
CraigMake sure you have a suitable ORDER BY clause at the end of your query.|||I tried adding "ORDER BY Tag" but I still got the same error. I added it jus
t
before the "FOR XML EXPLICIT".
Is that right ? Or should I be doing something else ?|||The ORDER BY clause will be dependent upon the rest of the query,
perhaps you could post your query (or a cut down version of it
if it is very big)|||The order by needs to make sure that the parent element is immediately
followed by its children.
The error message that you see means that a child element appears before its
parent.
Best regards
Michael
<markc600@.hotmail.com> wrote in message
news:1122495791.208708.274880@.g47g2000cwa.googlegroups.com...
> The ORDER BY clause will be dependent upon the rest of the query,
> perhaps you could post your query (or a cut down version of it
> if it is very big)
>|||I have checked this and all parent elements are immediately followed by its
children.|||Can you provide a repro case then?
Thanks
Michael
"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:E27D6043-CE20-4BE8-816E-677A7B015D6B@.microsoft.com...
>I have checked this and all parent elements are immediately followed by its
> children.

FOR XML EXPLICIT error: Undeclared tag ID

I am exporting xml from SQL Server 2000 using a FOR XML EXPLICIT query. It is
quite a big query: 56 SELECTs unions together and each one has 57 columns.
When I run it, I get the following error...
Server: Msg 6806, Level 16, State 2, Procedure DebitNotes_XmlDoc2, Line 10
Undeclared tag ID 50 is used in a FOR XML EXPLICIT query.
By the way, if I remove "FOR XML EXPLICIT", the remaining part works.
Does anyone know what that error means ?
Thanks,
Craig
Make sure you have a suitable ORDER BY clause at the end of your query.
|||I tried adding "ORDER BY Tag" but I still got the same error. I added it just
before the "FOR XML EXPLICIT".
Is that right ? Or should I be doing something else ?
|||The ORDER BY clause will be dependent upon the rest of the query,
perhaps you could post your query (or a cut down version of it
if it is very big)
|||The order by needs to make sure that the parent element is immediately
followed by its children.
The error message that you see means that a child element appears before its
parent.
Best regards
Michael
<markc600@.hotmail.com> wrote in message
news:1122495791.208708.274880@.g47g2000cwa.googlegr oups.com...
> The ORDER BY clause will be dependent upon the rest of the query,
> perhaps you could post your query (or a cut down version of it
> if it is very big)
>
|||I have checked this and all parent elements are immediately followed by its
children.
|||Can you provide a repro case then?
Thanks
Michael
"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:E27D6043-CE20-4BE8-816E-677A7B015D6B@.microsoft.com...
>I have checked this and all parent elements are immediately followed by its
> children.

For MS Development Team - SP2

Hello,
I am experiencing an issue with exporting to Excel - on some reports the
last row is missing. Is there a hot fix for this and/or is this addressed in
SP2 for Reporting Services?
TIA.
--
Chris HanleyMost likely:
http://www.ReportingServicesFAQ.com/ow.asp?SP2ForRS%3F
chanley54 wrote:
> Hello,
> I am experiencing an issue with exporting to Excel - on some reports the
> last row is missing. Is there a hot fix for this and/or is this addressed in
> SP2 for Reporting Services?
> TIA.