Working for/with High Caliber Folks

Within a couple of days of each other, both Andy Leonard (@AndyLeonard) and Paul Randal (@PaulRandal) tweeted about possible job opportunities which would...

Alternate Row Colors in an SSRS 2000 or 2005 Matrix

To create a "greenbar" report in a table with alternating row colors, you can simply
use the RowNumber function to determine...

BiTemporal Tables, anyone?

I'm doing some interesting research on using BiTemporal tables and I was wondering if anyone out there has any real-world...

Column Chart with Goal Threshold Line

Chart reports are an effective way to visualize data to show trends and comparisons
in a way that can help the...

Creating a Business Scorecard

Report Recipes

This is the second in a series of three articles highlighting the Report Solution
Patterns and Recipes from Chapter 7...

Creating a Recursive Report from a Parent Child Dimension

Reporting Services supports recursive hierarchies and Analysis Services supports parent-child
dimensions…

…and these two powerful features ought to just work together seamlessly,...

Displaying a Check Mark for a Row When a Related Record Exists

Let's say that you have a column
named some_id in an outer-joined table that will return a value if a record...

Format Date as Week of Month

You can define a calculated field for the datset outside of the query using a Visual
Basic.NET expression. In the Data...

How to Script Report Deployment, Move Reports or Change Properties

On the MSDN forums I see a lot of questions about how to use program code or command
line script to...

Location of the PASS Summit Follow-up

I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision...