sql-server-2008 - Sql Server 2008 报告服务 : Using two dataset error

Question

我正在构建一个使用两个数据集的报告。当我预览时，我发现这些类型的错误...

Error 19
[rsFieldReferenceAmbiguous]
The Value expression for the text box ‘Textbox3’ refers directly to the field ‘PerZipCode’ without specifying a dataset aggregate. When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions which specify a dataset scope.

需要什么聚合函数，哪里有设置它的选项？

Answer 1

如果您将多个数据集添加到报告中，上述内容可能无法解决您的问题。聚合时，您可能只会收到以下错误:

[rsMissingAggregateScope] The Value expression for the text box ‘textbox6’ uses an aggregate expression without a scope. A scope is required for all aggregates used outside of a data region unless the report contains exactly one dataset.

您可能需要的是:

First(Fields!MyField.Value, "DATASETNAME")

您可以通过使用表达式构建器获得，而不是从数据集中拖放字段。