本文介绍了SSRS可以使用像excel拖放这样的数据透视表吗的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SSRS 能做到这一点吗?这是我的意思的一个例子:http://demos.devexpress.com/XtraReportsDemos/DataBinding/PivotGridAndChart.aspx
Can SSRS do this?Here is an example of what I mean: http://demos.devexpress.com/XtraReportsDemos/DataBinding/PivotGridAndChart.aspx
推荐答案
你可以做这样的事情,虽然需要一些工作,它会有一些限制.
You can make something like this, althought needs some work and it will have some limitations.
1. Make a query that will contain all dynamic data field names
2. Create as much row and column groups as the maximum the user needs (4 rows and 2 columns are good in my opinion)
3. Create a param for each row and column. Assign to it the dataset with field names.
Eg. for row1 i created a parameter named R1
4. In each row and column the group should be =Fields(Parameters!R1.Value).value (replace R1 with your parameter's names)
5. Set row and column groups visibility to hidden if the user selection is none
Eg. for row2 the group visibility is =Iif(Parameters!R2.Value="none",true,false)
6. You can also create a param that will allow the user to select the measure he wants to see (value, quantity etc)
另见:http://www.simple-talk.com/sql/reporting-services/advanced-matrix-reporting-techniques/
这就像我做的那样
这篇关于SSRS可以使用像excel拖放这样的数据透视表吗的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!