truncation of text field in Sqlserver Reporting Services

amitabh04
amitabh04 used Ask the Experts™
on
Hi,
   One ot the text box is small even though set to expand in sql server reporting services. How do I fix the folowing error message?


Query execution failed for dataset 'DataSet1'.
String or binary data would be truncated. The statement has been terminated.


Thanks a lot.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
can you show me the query used in dataset?
For example this query will return this error:
declare @test1 as table(txt  text)
declare @test2 as table( vchr varchar(8))
insert into @test1(txt) values('0123456789')
insert into @test2(vchr) select txt from @test1
select * from @test2

Open in new window

The text in the txt field is too large for the vchr field. When you add
SET ANSI_WARNINGS OFF

Open in new window

at the top of the query you will get the result. But it might be better to fix the error instead of ignore it.

The error has nothing to do with the report itself. It's the query for Dataset1 that causes the problem.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial