Solved

NText field truncated in SQL Reporting Services Report

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Modifying SQL 2008/2012 PARTITIONS 3 55
Need help with a query 6 67
How to order Highest and lowest value rows alternatively in SQL Server ? 4 45
sql query help 2 45
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

895 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

11 Experts available now in Live!

Get 1:1 Help Now