SQL Server 2008 R2对3.0的印象

我一直在测试与2009年11月CTP SQL Server 2008 R2,本周我一直关注对3.0。这个产品已经走了很长的路自1.0版本是针对最终用户通过浏览器建立特别的报告。现在对3.0似乎也成为选择报告的GUI开发人员。让我们看一看。对1.0需要报告模型建立提前使用Visual Studio。报告模型为选定的表和视图将包含模板,用户可以建立报告。架构的好处是对会生成相同的RDL格式,也用于报表设计器在Visual Studio报告项目。高级用户可以快速生成强大的特别报告本身并发布给其他用户。无论如何,这是理论。究竟发生了什么是,微软已经发现大多数analyst-type用户喜欢使用Excel的使用一个直接连接到数据OLEDB提供者关系或多维数据库中。 Excel is a product they know inside and out. Learning a new product UI was always a tough sell. However, the report developers would gladly use ReportBuilder to generate powerful RDL reports with advanced features like infinite clickthrough, interactive sorting and drilldown without much effort. The RDL could then be opened using Report Designer for further editing (once you reset the Dataset to correctly point to the Report Model). But ReportBuilder would not support normal RDL reports built using Report Designer. Now, ReportBuilder 3.0 supports any RDL report regardless of where it was created and the GUI rivals that of Report Designer. ReportBuilder is launched from a browser using a button in Report Manager. It can also be executed from a URL from your own application or from Sharepoint. Effectively, the application is downloaded via http and run on the client machine. It can now also be installed locally and run from a Windows menu or shortcut. The new features in 3.0 include a Map Wizard so you can build an interactive map based on spatial data. You can include your own layer on top of the map to integrate with Virtual Earth, for instance. No mention of Google Earth surprise, surprise. I tested out the USA Map, with the States defined as spatial polygon objects. You can easily make them into hyperlinks for drilldown reporting. You can now create Shared Datasets so that queries can be reused in multiple reports. You can also create Report Parts that are reusable report items stored on the server. An example may be a chart that is needed on multiple reports. The idea is to be able to snap together a report from components. In the past we used Sub Reports and Stored Procedures so this gives us some extra options. Other features seem to have been borrowed from Excel. Now we have Sparklines and Data Bars for some extra visualization effects. The Excel export feature itself now allows you to export selected page breaks to named worksheets within the Excel file. I tested out ReportBuilder 3.0 using the "Create a Report" wizard and also editing existing reports built in Report Designer. It worked well. The GUI did seem to be much easier to use and all the features of Report Designer seemed to be there. So now you have a viable choice and can switch back and forth as you please. Let the users have Office and Excel. We'll keep ReportBuilder for ourselves, no problem. cheers Brian