时间戳

首页 > 解决方案 > SQL Server 报告：将数据类型 nvarchar 转换为数字时出错

sql - SQL Server 报告：将数据类型 nvarchar 转换为数字时出错

问题描述

我们的实时系统上运行着 SQL Server Reporting Services。但是当我们尝试将相同的报告移动到新的数据库和新的报告服务器时，报告开始失败并出现以下错误。

非常感谢有人可以提供帮助

SQL Server Reporting Services 显示此错误

报告处理过程中发生错误。(rsProcessingAborted)
无法读取数据集“DSProductJournal”的下一个数据行。(rsErrorReadingNextDataRow)
将数据类型 nvarchar 转换为数值时出错。

SQL查询

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]

标签： sqlsql-servertsql

解决方案

只是想更新。通过添加 WHERE [Shelf No_] IN (SELECT Value FROM dbo.FnSplit(@LOB,',')) 解决了这个问题

并将 =join(Parameters!LOB.Value,",") 添加到参数中

推荐阅读