Using Crystal Reports XI, and using the command feature with this simple query:

select
Field1 AS Item,
Field2  AS Customer
from
Server.DB.dbo.Table whereField1 =   {?Parameter_String}

Returns an error: Conversion of Value overlowed an Int Column.

If the parameter value is one that matches a record, it works.
If the value is hard coded, then zero records are returned and there is no error - it works.
If the parameter value is one where no records match, then the error occurs.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.