question

yxzhou624 avatar image
yxzhou624 asked

Error converting data type nvarchar to int

Hi, I have a simply report and would like to pass multiple INT value parameter (Product ID 'int') when I am running the report. When I choose the single value (Product ID), it runs well. But when I choose more than one value, in the report preview, it shows 'Error converting data type nvarchar to int' . Does anyone have any idea about fixing this 'simple' problem? I think maybe i need to convert the parameter in SP. But I tried 2 days and got nothing. Realllllly Appreciate It!!
stored-proceduresssrs-2008convertdatatypes
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
How are you passing those values into the query? What's the report engine doing with those to generate a SQL Statement to pass back to SQL Server for execution?
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.