NText field truncated in SQL Reporting Services Report

I have a SQL Reporting Services 2005 report displaying an NTEXT field in a Table Control Row field.  One record is truncated.  I cannot determine how large the field is.  The report textbox cangrow property is set to true.  There must be a limit on the size of a text box field in a table control.  How can I change the report and/or SQL so that all the data can be displayed correctly?
edbrinkmAsked:
Who is Participating?
 
Brendt HessSenior DBACommented:
There is a maximum of 32,000 characters that can be displayed in a single textbox in reporting services.  See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3511134&SiteID=1 for a (very short) discussion.

Your only alternative is to add a number of textboxes to your report side by side, then partition the text out if there is more than 32k in one text field.
0
 
edbrinkmAuthor Commented:
You mean to use an SQL function to break the ntext field in to 32k array pieces and populate the text boxes correct?
0
 
edbrinkmAuthor Commented:
when I use datalength function on the specific record's field, the length is 26986
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.