报表生成器2中的SumDistinct [英] SumDistinct in report builder 2

问题描述

亲爱的，

我正在使用报表生成器2生成报表.
假设我查询的数据如下所示:

Dear,

I am building a report using report builder 2.
let say the data from my query is look like below:

Select membershipid,billamount,transactionAmount
From  membership m inner join bill b on b.membershipid=m.id
left outer join transaction t on t.billId=b.id

MembershipId(membership Table) billAmount(bill)  TransactionAmount (transaction)
1                              100                   20
1                              100                   20
1                              100                   50
1                              100                   10
2                              50                    10
2                              50                    10 
2                              50                    20

当我在报表生成器中使用MemberId上的行组时，然后添加总计组
，报告输出是这样的:

when I used the row group in report builder on membershipId then add Total group
,report output is like this:

1                             400                  100
2                             150                  50

我想看到此输出:

I want to see this output:

1                             100                  100
2                             50                   50

为什么会发生?我该怎么办?

why this happen?and What should I do؟

推荐答案

实现此目标的唯一方法是更改​​查询:

The only way to achieve that is to change a query:

SELECT membershipid, billamount, SUM(transactionAmount) AS transactionAmount
FROM  membership m inner join bill b on b.membershipid=m.id
left outer join transaction t on t.billId=b.id
GROUP BY membershipid, billamount
ORDER BY membershipid, billamount

并删除报告中的分组.

and remove groupping in the report.

这篇关于报表生成器2中的SumDistinct的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！