An Introduction to Data Bars in SQL Server Reporting Services 2008 R2

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 correlations between multiple values, or in the case of a single column, to simply…

7

SQL Server Reporting Services 2008 R2 Map Tip: Address Geocoding with SQL Server 2008 Spatial

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 just addresses. Can you map that?” The answer to…

0

Working with XY Scatter Charts in Reporting Services 2008

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 and will work to improve them in a future release.  The remainder of this post will…

8

Enabling Drilldown on (SSRS) Reporting Services 2008 Charts

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.  First, create a connection to the Analysis Services database, and in…

12

Attending SQL PASS Community Summit This Week

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 like to stop by and say "hello".    Should be…

2

SSRS and Microsoft Chart Control How To: Change the Width of Bars and Columns

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 of the bars and columns on the charts?". …

7