x
login about faq Site discussion (meta-askssc)

SSRS returned row truncated in a dataset

Hi everyone, a few days ago I found an issue that I think was originated by the length of the report parameter, but I think that I found the real problem. I have a dataset which is must be filled with one simple row (xml type), the thing is that the xml returned was truncated and instead of return one simple row the dataset is had been filled with 3 rows because the xml is too long and it has been splitted in to many pieces. How can I obtain one simple row in my dataset? This situation has been a real headache and is a very urgent thing :'(

Thanks in advance!!!

more ▼

asked Jul 20 '12 at 03:05 PM in Default

anitam27 gravatar image

anitam27
0 1 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Question here http://www.sqlservercentral.com/Forums/Topic126921-21-1.aspx seems to suggest that this is an odbc issue

more ▼

answered Jul 20 '12 at 03:38 PM

Kev Riley gravatar image

Kev Riley ♦♦
46.1k 38 43 69

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x486
x8

asked: Jul 20 '12 at 03:05 PM

Seen: 375 times

Last Updated: Jul 20 '12 at 03:38 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.