SSRS 2008 R2减去上一行中汇总数据的当前行(SSRS 2008 R2 Subtracting current row from previous row where data is summed)

我是SSRS 2008 R2的新手。 试图从Crystal转换我的报告。 认为这将是一个简单的任务，但这最终是一个痛苦。 我有一个按年份分组的表，然后是Week_Number，因此表格在运行时会显示:(我正在尝试创建总行）

Week1 Week2 Week3 Week4 2013 1 2 5 4 2014 0 3 2 6 Total -1 1 -3 2

有一个名为Year的行组和名为Week_Number列组。 我在总列Sum(Fields!TotalProdWTD.Value)有一个表达式。

我添加了一个组页脚来尝试创建总行。 我可以总结列的工作正常，我可以通过执行此ReportItems!txtTotalProd.Value获取最后一行的值ReportItems!txtTotalProd.Value 。 但是当我尝试使用时

=Previous(ReportItems!txtTotalProd.Value)

我得到的聚合函数只能用于页眉和页脚消息中包含的报表项。 我相信我必须添加对该组的引用以使之前的功能工作，只是不确定如何做到这一点。

I am fairly new to SSRS 2008 R2. Trying to convert my reports from Crystal. Thought this would be a simple task but this ended up being a pain. I have a table that is grouped by Year then Week_Number so the table looks this when run: (I am trying to create the total row)

Week1 Week2 Week3 Week4 2013 1 2 5 4 2014 0 3 2 6 Total -1 1 -3 2

There is a row group called Year and column group called Week_Number. I have one expression in the total column Sum(Fields!TotalProdWTD.Value).

I added a group footer to try create the total row. I am able to sum the column works fine, I can get the value of the last row by doing this ReportItems!txtTotalProd.Value. But when I try to use

=Previous(ReportItems!txtTotalProd.Value)

I get the aggregate functions can be used only on report items contained in page headers and footers message. I believe I have to add a reference to the group to make the previous function work, just not sure how to do that.

最满意答案

使用报表在下面的组外插入新行

并使用您的命令：Sum（Fields！TotalProdWTD.Value）到表达式文本框

I found what I was looking for here. At the bottom of the article: http://msdn.microsoft.com/en-us/library/ms157328.aspx

SSRS 2008 R2减去上一行中汇总数据的当前行(SSRS 2008 R2 Subtracting current row from previous row where data is summed)

我是SSRS 2008 R2的新手。 试图从Crystal转换我的报告。 认为这将是一个简单的任务，但这最终是一个痛苦。 我有一个按年份分组的表，然后是Week_Number，因此表格在运行时会显示:(我正在尝试创建总行）

Week1 Week2 Week3 Week4 2013 1 2 5 4 2014 0 3 2 6 Total -1 1 -3 2

有一个名为Year的行组和名为Week_Number列组。 我在总列Sum(Fields!TotalProdWTD.Value)有一个表达式。

我添加了一个组页脚来尝试创建总行。 我可以总结列的工作正常，我可以通过执行此ReportItems!txtTotalProd.Value获取最后一行的值ReportItems!txtTotalProd.Value 。 但是当我尝试使用时

=Previous(ReportItems!txtTotalProd.Value)

我得到的聚合函数只能用于页眉和页脚消息中包含的报表项。 我相信我必须添加对该组的引用以使之前的功能工作，只是不确定如何做到这一点。

I am fairly new to SSRS 2008 R2. Trying to convert my reports from Crystal. Thought this would be a simple task but this ended up being a pain. I have a table that is grouped by Year then Week_Number so the table looks this when run: (I am trying to create the total row)

Week1 Week2 Week3 Week4 2013 1 2 5 4 2014 0 3 2 6 Total -1 1 -3 2

There is a row group called Year and column group called Week_Number. I have one expression in the total column Sum(Fields!TotalProdWTD.Value).

I added a group footer to try create the total row. I am able to sum the column works fine, I can get the value of the last row by doing this ReportItems!txtTotalProd.Value. But when I try to use

=Previous(ReportItems!txtTotalProd.Value)

I get the aggregate functions can be used only on report items contained in page headers and footers message. I believe I have to add a reference to the group to make the previous function work, just not sure how to do that.

最满意答案

使用报表在下面的组外插入新行

并使用您的命令：Sum（Fields！TotalProdWTD.Value）到表达式文本框

I found what I was looking for here. At the bottom of the article: http://msdn.microsoft.com/en-us/library/ms157328.aspx