<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
In SSRS I am connected to an AS400 using an ODBC connection.<br />
<br />
I have a select statement as follows.<br />
<br />
Select item <br />
From library.itemmaster<br />
Where Itemtype in ?<br />
<br />
I get the following error when I run the SQL statment in desinger<br />
CWB0111 - Input data is too big to fit into field<br />
<br />
If I create a report parameter and preview the report I get the following error<br />
Cannot add multi value query parameter ? for dataset 'DataSet1' because it is not supported by the data extension.<br />
<br />
What causes this and is there a work around?
</div>
</div>


In SSRS I am connected to an AS400 using an ODBC connection.

I have a select statement as follows.

Select item 
From library.itemmaster
Where Itemtype in ?

I get the following error when I run the SQL statment in desinger
CWB0111 - Input data is too big to fit into field

If I create a report parameter and preview the report I get the following error
Cannot add multi value query parameter ? for dataset 'DataSet1' because it is not supported by the data extension.

What causes this and is there a work around?

CWB0111 - Input data is too big to fit into field

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.