报告服务-将Tablix列值相加 [英] reporting services - sum tablix column values

问题描述

我对tablix列中的行应用了许多功能.我需要对tablix列中的所有行求和.我使用的是Reporting Services 2005，因此LOOKUP不存在，并且也无法访问SQL存储过程.

I have many functions applied to rows in a tablix column. I need to sum all the rows in a tablix column. I am using reporting services 2005, so LOOKUP doesn't exist and I also do not have access to the SQL stored procedure.

推荐答案

您的问题相当模糊，但是我会解决这个问题.假设您在tablix列中有一个名为Textbox5的文本框.在页脚行(组页脚或tablix页脚)中，可以使用以下表达式:

Your question is rather vague, but I'll take a crack at the problem. Let's say that you have a textbox in the tablix column called Textbox5. In a footer row (either a group footer or the tablix footer), you can use an expression like this:

=Sum(ReportItems!Textbox5.Value)

在每一行中的函数解析之后，它将汇总该文本框中的值.

That will sum up the values in that textbox after the functions have been resolved in each row.

这篇关于报告服务-将Tablix列值相加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！