如何在矩阵报告服务中显示数据透视表?
我有与数据透视查询和矩阵报告相关的问题。我不知道如何在矩阵报告服务上显示它,因此它将动态列。任何人都可以帮助我展示如何配置矩阵表吗?或者您能给我在哪里可以找到问题答案的链接吗?我是报告服务的新手。
I have problem relating to pivot query and matrix reporting. I don't know how to display it on matrix reporting service so it will dynamic column. Can any body help me to show how to configure the matrix table? or could you give the link where can I find the answer of my problem? I'm newbie in reporting service.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
将矩阵控件视为“设计时数据透视表”
一旦设计完成并呈现数据,输出就是固定的 - 您不能像使用数据透视表那样进行拖放。
矩阵控件可以具有动态行/列分组,这些分组将随着您的数据而增长。
一旦您了解了“inscope”的概念,它就非常容易使用。
要创建动态列,您只需创建一个列分组(将其拖到表单上后,朝向矩阵控件的右上部分)只需告诉它使用哪个字段作为分组即可。
Think of a matrix control as a 'design time pivot table'
Once it has been designed and it has rendered the data, the output is fixed - you cannot drag and drop like you would with a pivot table.
The matrix control can have dynamic row/column groupings which will grow with your data.
It's pretty easy to use once you get your head around the concept of 'inscope'
To create dynamic columns, you just need to create a column grouping (towards the top right section of the matrix control once you have dragged it on to the form) Just tell it which field to use as a grouping.