reporting-services - SSRS 返回的数据类型对聚合函数无效

Question

执行查询时，我正在制作 SSRS

SELECT Brand.[KeyOffer],
   COALESCE(SUM([Key Offer].Revenue),0) as Revenue
FROM [Brand Key Offer] Brand
LEFT JOIN [Key Offer] ON Brand.Keyoffer = [Key Offer].[Key Offer] AND [Key Offer].[Date] = '7/05/2017'
WHERE Brand.[Brand] = 'SMART'
GROUP BY [Brand].[KeyOffer]
ORDER BY [Revenue] DESC

但是当我预览 reprot 时，我收到此警告消息。

Warning     [rsAggregateOfInvalidExpressionDataType] The Value expression for the textrun ‘Textbox21.Paragraphs[0].TextRuns[0]’ uses an aggregate function with an expression that returned a data type not valid for the aggregate function.       c:\users\t-aordiz\documents\visual studio 2015\Projects\TelemarketingRS\TelemarketingRS\Telemarketing Revenue.rdl   0   

我去过很多主题，但似乎无法找到解决此问题的方法。

Answer 1

当我尝试将输出的数据类型从 datetime 更改为 varchar 时，同样发生在我身上。

尝试删除文件 YourReportFile.rdl.data 并再次预览。它在 VS2015 中对我有用。