问题描述
我回来回答另一个 SSRS 问题:-)
I'm back with another SSRS question :-)
我正在处理调查数据.我有一个程序可以返回组织对每个问题的响应计数.所以我的报告被定义为行的组织组和列的答案组.组织的数量和答案都是可变的.这按预期工作.我尝试在组织旁边添加一个 RowCount,以便我可以显示排名,但事实上每个组织每个问题都有一行意味着我每个组织有八行.
I'm dealing with survey data. I have a procedure that's returning an organization's response counts per question. So my report is defined as Group on Organization for row and Group on answer for columns. Both the number of organizations and answers are variable. That's working as expected. I've tried adding a RowCount next to the organization so that I can show rank, but the fact that each org has one row per question means that I'm getting eight rows per org.
这是一个例子:
Here's an example:
这是我的报告定义:
排名表达式当前为:=RowNumber(Nothing)
理想情况下,排名将是 1、2、3、4 等......我已经尝试将范围限定为行组、列组,但什么也没有.没有帮助.
Ideally, the rank would be 1, 2, 3, 4, etc... I've tried scope to the row group, column group and nothing. No help.
任何帮助将不胜感激!
推荐答案
我似乎找到了一个解决方案,但感觉就像一个黑客......我没有回答这个问题,看看其他人是否可以提供更好的解决方案(少读hackish).
I seem to have found a solution, but it feels like a hack... I'm leaving this unanswered to see if someone else can provide a better solution (read less hackish).
我的排名表达式现在是:=RowNumber(Nothing)/Count(Fields!AnswerText.Value)
My Rank Expression is now:=RowNumber(Nothing)/Count(Fields!AnswerText.Value)
似乎一切正常.我想我应该 IIf(Count... = 0, Then RowNumber, else what I've got...
Everything seems to be ok. I suppose I should IIf(Count... = 0, Then RowNumber, else what I've got...
这篇关于SSRS 行组 + 列组 = RowNumber 问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!