ssrs 2008r2在两个数据集之间进行计算(ssrs 2008r2 calculate between two datasets)

ssrs 2008r2在两个数据集之间进行计算(ssrs 2008r2 calculate between two datasets)

在我的报告中，目前有两个表，每个表绑定到一个数据集

table 1 (dataset 1): date1, date2 (column group) value1, value2 table 2 (dataset 2): date1, date2 (column group) value3, value4

date1，每个表中的date2具有相同的值。 我想要实现的目标：

在表2中再添加一行，所以它看起来像这样：

table 2 (dataset 2): date1, date2 (column group) value3, value4 value1/value3, value2/value4

如您所见，value1和value2来自表1（数据集1），无论如何要实现这一目标吗？ 我知道我可以在SQL中执行此操作，但想知道这是否可以在SSRS中实现？

In my report currently there are two tables, each binding to a dataset

table 1 (dataset 1): date1, date2 (column group) value1, value2 table 2 (dataset 2): date1, date2 (column group) value3, value4

date1, date2 in each table have the same values. What I want to achieve:

in table 2 add one more row, so it will looks like this:

table 2 (dataset 2): date1, date2 (column group) value3, value4 value1/value3, value2/value4

As you can see, value1 and value2 are from table 1(dataset 1), is there anyway to achieve this? I know I can do this in SQL but would like to know if this achievable in SSRS?

最满意答案

使用查找的示例..

使用两个数据集..

两个数据集之间的链接是Dataset1.id = Dataset2.DSid

至于你的描述，将Dataset1的值除以Dataset2的值。

在表格详细信息中，使用表达式..

=Fields!totalhold.Value / Lookup(Fields!id.Value, Fields!DSid.Value, Fields!totalh.Value, "DataSet2")

Example to use the lookup ..

Using two datasets ..

The link between the two data set is Dataset1.id = Dataset2.DSid

As to your description to divide value from Dataset1 with value from Dataset2.

In the table detail, use expression ..

=Fields!totalhold.Value / Lookup(Fields!id.Value, Fields!DSid.Value, Fields!totalh.Value, "DataSet2")