Solved

NText field truncated in SQL Reporting Services Report

Posted on 2008-10-01
3
726 Views
Last Modified: 2012-08-14
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?
0
Comment
Question by:edbrinkm
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
bhess1 earned 500 total points
Comment Utility
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
 

Author Comment

by:edbrinkm
Comment Utility
You mean to use an SQL function to break the ntext field in to 32k array pieces and populate the text boxes correct?
0
 

Author Comment

by:edbrinkm
Comment Utility
when I use datalength function on the specific record's field, the length is 26986
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now