A common question that I get when introducing the map feature in SQL Server 2008 R2 Reporting Services is why the map gallery is limited to maps of the United States and individual states in the US. The reason as I’ve heard it explained is that the political boundaries for other countries are sometimes in [...]

Winding down on the authoring process of my latest book, Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010, I decided to look at my calendar to see what I should work on next, and saw that I have a lot of presentations to prepare! Here’s a list of events planned [...]

This month’s T-SQL Tuesday is hosted by Jorge Segarra (blog | twitter) who decided that we should write about our favorite new feature in SQL Server 2008 R2. The majority of my published works concentrates on Reporting Services, so the obvious answer for me with regard to favorite new features is…Reporting Services. I can’t pick [...]

Host Michael Coles (blog|twitter) has selected LOB data as the topic for this month’s T-SQL Tuesday, so I’ll take this opportunity to post an overview of reporting with spatial data types. As part of my work with SQL Server 2008 R2 Reporting Services, I’ve been exploring the use of spatial data types in the new [...]

If you have any experience at all with Reporting Services, you have probably developed a report using the matrix data region. It’s handy when you want to generate columns dynamically based on data. If users view a matrix report online, they can scroll horizontally to view all columns and all is well. But if they [...]