Forum Discussion
Neka
Helper III
Helper IIISmallInt parameter in paginated report won't work as available values and default values
Hello, I am working on a paginated report that has a parameter that is a smallint. I originally want the report to load showing all rows without the effect of the parameter. I want this param...
This error sounds like you have a NVARCHAR column that you are trying to insert into an smallint, but some of the values in that column are not valid
if you do the following I suspect you will get the same error.Select DISTINCT CAST(paramItems as smallint)
FROM table
You probably need to either fix your data or convert your parameter to a text parameter
d_gosbell
Super User
Super UserThis error sounds like you have a NVARCHAR column that you are trying to insert into an smallint, but some of the values in that column are not valid
if you do the following I suspect you will get the same error.
Select DISTINCT CAST(paramItems as smallint)
FROM table
You probably need to either fix your data or convert your parameter to a text parameter