Solving All Versus (Select All) SSRS End User Confusion

When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...

SPB Applications for Windows Mobile

<<placeholder>>

…for product review

Weblog by Paul Turley and SQL Server BI Blog.

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...