Tuesday, November 24, 2009

SQL Server 2008 R2 CTP November with some nice visualization features.


The feature complete build of SQL 2008 R2 is available for download. This November CTP build fixes the issue I blogged in the past: The report definition has an invalid target namespace 'http://schema.microsoft.com/sqlserver/reporting/ 2009/01/reportdefinition' which cannot be upgraded.

Now it is possible to install SQL 2008 R2 Reporting Server on a machine which you uses to build and deployed SQL 2008 reports. Please read the details about how you can use an installation of SQL 2008 R2 on a machine with SQL 2008:

- RDL files: In the SQL Server 2008 R2 version of Business Intelligence Development Studio, you can work with both SQL Server 2008 R2 and SQL Server 2008 versions of report definitions and Report Server projects.


If you open, update, and then save a SQL Server 2008 report definition, it is saved as SQL Server 2008 report definition unless you added features that are new SQL Server 2008 R2.

- SSRS projects: You can add and open SQL Server 2008 Report Server projects to solutions that you create using the SQL Server 2008 R2 version of Business Intelligence Development Studio.

However , if you save the SQL Server 2008 Report Server project it saved as SQL Server 2008 R2 Report Server project and you can no longer open it in the of Business Intelligence Development Studio

 
Enjoy using SQl 2008 R2 with next nice data visualization features:

Maps to visualize of for instance your customers. Read: How to enrich your account data with longitude, latitude and geography data.











Indicators

 
 
 













Sparklines



















Data bars


No comments: