reporting services - sum tablix column values

2020-05-07 14:59发布

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.

2条回答
淡お忘
2楼-- · 2020-05-07 15:35

And aggregate function can be used only on report items place in Header or Footer !!!!

查看更多
闹够了就滚
3楼-- · 2020-05-07 15:40

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.

查看更多
登录 后发表回答