We have SQL Server Reporting Services running on our live system. But when we trying to move same reports in to new database and new reporting server, then reports starting to fail with below error.
Highly appreciate if someone can help
SQL Server Reporting Services is showing this error
___-
An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset 'DSProductJournal'. (rsErrorReadingNextDataRow)
Error converting data type nvarchar to numeric.
SQL query
__--
SELECT
COMPANY, [Table], [Service Item Group],
(CAST([Line No] AS char(10)) + [Order No]) AS [Line No],
[Item No_], [Shelf No_], Quantity, [Serial No_], [Order No_],
Name, [Weight], Dimension, [Satus/OwnerShip], Condition,
[E.T.A. / Rec’d Date], [Cost Amount (Actual)], [Cost Curr],
[Costing Completed], [Currency Code], [Exchange Rate Amount],
Special, [(Sales Price).(Unit Price)], [(Sales Price).(Minimum Quantity)],
[COSTED S/P CDN], [Location Code], [Profit ] AS [Profit],
[Description Sales Price] AS [DescriptionSalesPrice],
[Currency Code.Sales Price]
FROM
dbo.V_ZItemLedgerEntryPurchLineUnionAll
WHERE
[Shelf No] IN (@LOB)
ORDER BY
[Service Item Group]
-
(@LOB) is a user input. we noticed that as soon as we remove "WHERE
[Shelf No_] IN (@LOB)" and reportstart running. please help

