在我的报告中,目前有两个表,每个表绑定到一个数据集
table 1 (dataset 1): date1, date2 (column group) value1, value2 table 2 (dataset 2): date1, date2 (column group) value3, value4date1,每个表中的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, value4date1, 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/value4As 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")更多推荐
发布评论