Solved

NText field truncated in SQL Reporting Services Report

Posted on 2008-10-01
3
751 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 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