如何在 SQL Reporting Services 模型中包含数据库的视图
我是 SQL Reporting Services 的新手。我需要从数据库中的 SQL 视图创建报告。当我将数据库添加为数据源并从该数据源生成模型时，该模型包含数据库的表，但不包含其视图。
有没有办法将视图包含在模型中，以便我可以在报告中使用它们？
其他详细信息：使用 SQL Server 和 Reporting Services 2005
I am new to SQL Reporting Services. I need to create a report from a SQL view in my database. When I add the database as a data source and generate a model from that data source, the model includes the database's tables, but not its views.
Is there a way to include the views in the model so I can use them in my report?
Additional Details: Using SQL Server and Reporting Services 2005
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
一位朋友指出，这里的问题是模型对于我想做的事情来说并不是必需的。我认为有必要的原因是，Report Builder 1.0 要求您在创建报告时选择一个模型。然而，Business Intelligence Development Studio 不支持（Report Builder 版本 2+ 也不支持）。
我将在 Business Intelligence Development Studio 中制作报告。
A friend pointed out that the problem here is that a model is not necessary for what I want to do. The reason I thought it was necessary is because Report Builder 1.0 requires you to select a model when you create the report. Business Intelligence Development Studio, however, does not (Neither do Report Builder versions 2+).
I will be making the report in Business Intelligence Development Studio instead.
http://msdn.microsoft.com/en -us/library/ms345300%28v=sql.105%29.aspx
这是通过 Business Intelligence Studio 创建模型的有用链接（也可以包含视图）。
http://msdn.microsoft.com/en-us/library/ms345300%28v=sql.105%29.aspx
This is a useful link to create a model via Business Intelligence Studio (which can include views too).