闪光线，数据条和指标

ReportBuilder 3.0是SQL Server 2008 R2的一个主要部分，它允许您在Visual Studio 2008的报表设计器之外的另一个报表编辑器。一些新功能包括闪光线，数据条和指标。我已经用SQL Server 2008 R2 Nov CTP测试了它们。让我们来看看。闪光线是可以包含在数据区域(如报表和矩阵)中的“迷你图表”。它们没有标题、图例、轴线或标签，但除此之外，它们就像您希望嵌入到报表数据中的小图表。因为闪光线总是显示聚合的数据，所以它们必须包含在与组关联的单元格中。例如，您可以用每个销售代表在一段时间内的销售额来表示他们汇总的总摘要。你可以选择你想要的图表类型，包括直线，直方图，饼图等。数据条通常以条形显示单个数据点。 This feature is very similar to the equivalent concept in Excel 2007 and beyond. It gives a visual representation of a value so you can immediately compare values without having to look a the actual numbers. Again, Data Bars can be embedded within your report data. Indicators are very similar to the Analysis Services feature called Key Performance Indicators (KPI) except for any type of data not just multi-dimensional cubes. It gives a numeric value a visualization like arrows or stars or traffic light colors. Again, the end-user can quickly see the status of a business critical value via a visual icon to quickly identify problem areas or areas of success. In testing, all these features worked well in ReportBuilder 3.0. In Report Designer 2008 R2, Sparklines and Data Bars worked fine, but the indicator feature caused an error stating "SQL Server 2008 Reporting Services does not support state indicators" at preview time. Don't worry, this version is still a CTP so I will report it and the issue will be fixed in time for the official R2 release later this year. If that's my worst bug, I will be very happy with this release. cheers Brian