vb.NET 中带有 rdlc 报告的问题小计矩阵

发布于 2024-08-26 20:42:33 字数 450 浏览 9 评论 0原文

我有一个矩阵，我需要将今年和过去几年赚的钱相加。但是，我必须把过去几年花的钱去掉。我必须有每年的单独金额和这些金额的总和。这就是我的矩阵：

Year
= Fields!Year.value         =formatnumber((sum(Fields!Results.Value))-(sum(iif(
                          Fields!Year.value < Parameters!choosedYear.Value,
                          Fields!Moneyspent.value,0))), 2) & "$"

但是，小计给了我一个错误。我应该怎么办？

PS：我已经发现小计给了我一个错误，因为它不在 rowgroup1 的范围内，但是有没有办法获取小计中的范围？或者有人可以找到另一种方法来做到这一点吗？

原文

I have a matrix and I need to add the money earned this year and past years. However, I must remove the money spent in past years. I must have the separate amount per year and the total of these amounts. This is what gives my matrix:

Year
= Fields!Year.value         =formatnumber((sum(Fields!Results.Value))-(sum(iif(
                          Fields!Year.value < Parameters!choosedYear.Value,
                          Fields!Moneyspent.value,0))), 2) & "$"

However, the subtotal gives me an error. What should I do?

P.S.: I already found that the subtotal gives me an error because it's not in the scope of the rowgroup1, but is there a way to get the scope in the subtotal? or can anybody find another way to do it?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

可是我不能没有你 2024-09-02 20:42:33

尝试这样

=formatnumber(sum(Fields!Results.Value)-iif(
                          Fields!Year.value < Parameters!choosedYear.Value,
                          sum( Fields!Moneyspent.value), 0), 2) & "$"

try like this

=formatnumber(sum(Fields!Results.Value)-iif(
                          Fields!Year.value < Parameters!choosedYear.Value,
                          sum( Fields!Moneyspent.value), 0), 2) & "$"

回复收藏 0 原文

~没有更多了~