With the release of SQL Server “Denali” CTP3, we are introducing Project “Crescent”.  Project Crescent is Reporting Services’ new reporting tool targeted at data consumers to visually explore their data and answer ad-hoc questions with ease. ...

If you are using maps in SSRS 2008 R2, you might be aware that the Map Wizard only provides U.S. based maps. However, it is totally possible to add more maps to the gallery. Head on over to http://mapgallery.codeplex.com/ where a community project has...

While the map in SSRS 2008 R2 supports different data sources for spatial data (ESRI shape files, SQL Server spatial, and included maps in the Map Gallery), sometimes that may not be enough for your needs.  Another way you can get spatial data into...

Today, the Reporting Services team gave a series of presentations at an all day “airlift” event.  Here are the reports and database backup for the demo I gave.  In future posts, I will  walk through building this report.  Thank you...

Data Bars are a new feature in SQL Server Reporting Services 2008 R2 introduced with the November CTP.  Data Bars are useful for building what are often referred to as “trellis” and “table lense” displays that help report consumers indentify possible...

This post is just a pointer to a great blog post on Spatial Ed ’s blog that addresses (pun intended) one of the most common questions I get regarding the map in Reporting Services which is, “In my database, all of my store locations, customers, etc. are...

In the August CTP of SQL Server 2008 R2, we introduced the map report item in Reporting Services.  As you might already be aware, the map in SSRS supports the spatial data types and functions that are available in SQL Server.  In this post,...

With the November CTP of SQL Server Reporting Services 2008 R2, we are introducing a new visualization in SSRS, sparklines.  Sparklines were developed by Edward Tufte and are described as “small, intense, simple data words” .  In this post we...

Recently, I’ve been fielding a few questions regarding XY Scatter Charts in Reporting Services 2008 (see MSDN Forum Question ).  We have definitely noticed that working with XY Scatter charts is a bit difficult, and we do appreciate the feedback...

In this post I'm going to spend some time covering a subject that comes up quite a bit on our forums , which is how to enable drill-down on a chart in Reporting Services. In this example, I'm using the Analysis Services 2008 AdventureWorks cube. ...

This is just a quick note to let people know that I'm attending the SQL PASS Community Summit this week. Here's a summary of where you can find me if you have some questions regarding data visualization or SQL Server Reporting Services, or if you'd just...

Every once and I while I get asked this question, and it fits nicely with a series I've been planning to blog on what you can do with custom attributes in charts in SQL Server Reporting Services 2008.  The question is, "How do I change the width...

Today, at PDC, the release of the Silverlight toolkit was made available.  Included in this release, is a preview version of a charting control that was produced as a collaborative effort between the Silverlight controls and SQL Server Reporting...

This is just a quick post to help spread the word that the Microsoft Chart Controls for .NET Framework 3.5 are now publicly available.  A big congrats to the team! Here are some useful links Downloads 1. Microsoft Chart Controls for Microsoft .NET...

This is my first post in what I hope is a long series of how to's related to data visualization. For my first post I'm going to demonstrate how you can add sparklines to your SSRS reports. Below is a screenshot of what a sparkline may look like in...