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, 2012 at 03:05 PM in Default

anitam27 gravatar image

0 2 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, 2012 at 03:38 PM

Kev Riley gravatar image

Kev Riley ♦♦
53.9k 47 49 76

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 20, 2012 at 03:05 PM

Seen: 834 times

Last Updated: Jul 20, 2012 at 03:38 PM