报告生成器3.0
我正在评估 SQL Server 2008 R2 上的 Ad-Hoc 报告工具。我想知道 SQL Server 附带的 Report Builder 3.0 有哪些限制。
我们可以在 VS 2008 中使用 BIDS 执行哪些报告，而在 Report Builder 3.0 中不能执行哪些报告 我们试图回答使用 Report Builder 可以做什么。
请分享您的实时体验
I am in the process of evaluiting Ad-Hoc reporting tool on top SQL Server 2008 R2. I would like to know what are the limitations around the Report Builder 3.0 which comes with SQL server.
What reports we can do in VS 2008 with BIDS and which we can not do in Report Builder 3.0 We are trying to answer what can be done what can be done with Report Builder.
Please share your real time experiance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
不久前我们也经历过同样的评估。基本上，BIDS 和 Report Builder 2/3 允许您做同样的事情。报表生成器适用于那些想要创建或修改自己的报表而无需安装 BIDS 的用户。报表生成器具有 Microsoft Office 的外观和风格。它具有类似于 Excel 和 Word 的功能区控件。两者生成相同的.RDL 或.RDLC。但是，Report Builder 3 仅针对 SSRS 2008 R2。 SSRS 2008 R2 的 .RDL 格式已更改。
无论哪种方式，报告都可以部署到 SSRS 服务器、Sharepoint 或 Microsoft Report Viewer（对于 .RDLC 文件）。
您可能知道也可能不知道，Visual Studio 2010 还没有出价。如果您想使用 BIDS，则需要使用针对 SQL Server 2008 的 VS 2008。
We went through this same evaluation not that long ago. Basically BIDS and Report Builder 2/3 allow you to do the same thing. Report Builder is for those users who want to create or modify their own reports without needing to install BIDS. Report Builder has a Microsoft Office look and feel. It has the ribbon controls similar to Excel and Word. The same .RDL or .RDLC is generated by both. However, Report Builder 3 only targets SSRS 2008 R2. The .RDL format has changed for SSRS 2008 R2.
Either way the report can be deployed to an SSRS server, Sharepoint or the Microsoft Report Viewer (for .RDLC files).
As you may or may not know, there is no BIDS for Visual Studio 2010 (yet). If you want to use BIDS, you'll need to use VS 2008, which targets SQL Server 2008.
我认为对于已经使用过 Cognos 和 Business Objects 等工具的高级用户来说，reprot builder 3.0 在针对多维数据集进行报告时似乎缺乏很多功能。这是主要的。
我无法创建可在报告中的多个表中使用的变量。我以为我可以使用“计算成员”，但它不允许我对立方体的任何对象使用任何类型的聚合函数，因为它将所有内容视为聚合对象。
我无法在查询过滤器中使用简单的“OR”语句。
高级用户在构建报表时需要始终关注“行组”，我认为这令人沮丧。在其他工具中，度量或事实分组仅按表中的维度进行分组。
导出到 Excel 时的行限制。
I think for a Power User who already has gone through tools like Cognos and Business Objects, the reprot builder 3.0 seems to lack lot of features while reporting against the cube. Here are the main.
I cannot create a variable which I can use in multiple tables in the report. I thought I could use "calculated member" but it does not let me use any kind of aggregate function on any of the objects against the cube as it treats everything as aggregate objects.
I cannot use a simple "OR" statement in the query filter.
Power user while building the report need to always pay attention to "row group", which I think is frustrating. In other tools the measure or fact groups it only groups by the dimension u have in the table.
Row limitations while exporting to excel.