报告服务 - 汇总 tablix 列值 [英] reporting services - sum tablix column values

问题描述

我将许多函数应用于 tablix 列中的行.我需要对 tablix 列中的所有行求和.我使用的是 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.

推荐答案

你的问题相当模糊，但我会解决这个问题.假设您在名为 Textbox5 的 tablix 列中有一个文本框.在页脚行(组页脚或 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屋！