Solved

NText field truncated in SQL Reporting Services Report

Posted on 2008-10-01
3
756 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 32

Accepted Solution

by:
bhess1 earned 500 total points
ID: 22616382
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
ID: 22616535
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
ID: 22617804
when I use datalength function on the specific record's field, the length is 26986
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
How to increase the row limit in Jasper Server.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

689 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