<div>
can you show me the query used in dataset?
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp;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?<br />
<br />
<br />
Query execution failed for dataset 'DataSet1'.<br />
String or binary data would be truncated. The statement has been terminated. <br />
<br />
<br />
Thanks a lot.
</div>
</div>


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.

truncation of text field in Sqlserver Reporting Services

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.