Power View and Reporting Services 2012 Book

Several projects kept me very busy over the past year. I will talk more about a few of these in subsequent postings now that some are publicly disclosed in the meantime. In this posting, I am very happy to announce the availability of “Professional Reporting Services 2012”. After the successful Report Design Recipes book focusing…

0

Turn-Based Gaming Against AI in RS Reports (aka BI Power Hour 2009)

At the traditional annual “BI Power Hour” sessions several teams contributing to the Microsoft Business Intelligence platform show off their technology in a fun way.  It is about demonstrating, in perhaps unusual ways, of how business intelligence and various tools of the BI stack can be useful. In past years, Reporting Services made a number…

2

SQL Server 2008 R2 RTM

  SQL Server 2008 R2 was just released to manufacturing (RTM) today. You can read more details about the overall SQL Server 2008 R2 release here.   SQL Server 2008 R2 is a big release, with new “editions” (MSDN contains the detailed feature by edition matrix), and includes also significant enhancements in Reporting Services. I summarized many…

0

SQL Server 2008 R2 November CTP – What’s New In Reporting Services?

The November CTP download is available for MSDN and TechNet subscribers. The public download is available here.  The feature pack download is now also available and includes Report Builder 3.0 as well as the RS add-ins for SharePoint 2007 and SharePoint 2010. The Data Platform Insider blog provides an overview of what’s new in CTP…

0

RS Maps with ESRI Shapefile

In a previous post, I demonstrated how to use a SQL Server spatial query as source for geospatial visualizations.  ESRI Shapefile is another type of spatial data supported in Reporting Services Maps in SQL Server 2008 R2 August CTP. There are a number of free ESRI shapefile data sources available for download on the web,…

0

RS Maps with Spatial Data and Bing Maps

SQL Server 2008 R2 August CTP includes map visualization functionality in Reporting Services, as briefly described yesterday.  In this posting, I’m going to provide an introduction of how to use spatial data and Bing Maps with Reporting Services Maps.  The attachment of this posting includes the final report so you can try it out yourself…

0

SQL Server 2008 R2 August CTP – What’s New In Reporting Services?

The August CTP download is available for MSDN and TechNet subscribers. The public download is now also active here. The Data Platform Insider blog provides an overview of what’s new in this first public CTP release for SQL Server 2008 R2.  If you are reading my blog, you are probably interested in knowing what’s new…

0

Multi-Player Gaming in RS (aka BI Power Hour 2008)

At the traditional annual “BI Power Hour” sessions, several teams that contribute to the Microsoft Business Intelligence platform show off their technology in a fun way.  It is about demonstrating, in perhaps unusual ways, of how business intelligence and various tools of the BI stack can be useful. In past years, Reporting Services made a…

4

Dynamic Drilldown in Reports and Charts

Just a quick post to reference two interesting reads about designing dynamic drilldown in reports: Sean Boon blogged about an approach to implement drilldown on charts with Reporting Services when Analysis Services is used as the data source.  Chris Webb then created a great blog posting on how to implement drilldown for Analysis Services based…

0

The Ultimate Guide to Color Scales / Conditional Formatting

I recently provided a tip to my Australian colleague David Lean to successfully solve a small report design challenge with tables and charts that use conditional formatting.  The specific goal was to dynamically calculate and assign a color shade so that the minimum value present in the data is shown red, the average value yellow, and the maximum value…

2