SSRS 最终用户设计器的工作效果如何？
我试图弄清楚这个工具是否足以让我的非技术用户自己构建报告。我知道他们需要对我向他们展示的数据模型有大量的业务/领域知识。但用户界面本身又如何呢？
有人以这种方式使用过 SSRS 报表生成器吗？您对此有什么经验？
构建和（主要）维护数据模型似乎需要大量的开发工作。有什么技巧吗？知道有什么好的地方可以参考吗？
谢谢。
I'm trying to figure out if this tool will be good enough for my non-technical users to build reports themselves. I know they will need to have a lot of business/domain knowledge about the data model I present them. But how about the UI itself?
Has anyone used the SSRS Report Builder in this way? What is your experience with it?
Building and (mostly) maintaining the data model seems like it will take a good deal of development effort. Any tips with this? Know any good places to look for reference?
thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这实际上取决于用户的理解水平。正如您所说，用户需要了解数据的布局。他们还需要了解基本的查询概念（过滤、分组、排序等）。一旦他们有了这些，就可以很容易地使用报告生成器创建报告。它实际上是拖放操作，尽管对于更复杂的查询，我建议用户为他们构建报告。我建议你自己玩一下。我不让用户随意使用报表生成器的主要原因是（据我所知）无法更改默认报表模板（报表需要适合公司字体、颜色等）。
就数据模型而言，设置非常简单，并且只要您的数据库架构不更改，就不需要维护。一旦定义了表、连接等，就这样了。在线图书此处提供了一些很好的演练。
It really depends on the level of understanding of the users. As you said, the users need to understand the layout of the data. They also need to understand basic query concepts (filtering, grouping, sorting etc.). Once they have that, it is easy to create reports with Report Builder. It is literally drag and drop, although for more complex queries I recommend to users that we build the reports for them. I suggest having a play with it yourself. My main reason for not letting users loose with Report Builder is that (AFAIK) there is no way to change the default report template (reports need to fit in with corporate fonts, colours etc.).
As far as the data model, it is pretty simple to set up and, provided your database schema doesn't change, requires no maintenance. Once the tables, joins etc are defined, that's it. Books Online have some good walkthroughs here.