Presenting at 2010 European PASS – Sort Of

I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...

Report Recipe Book Released

Our SQL Server Reporting Services Recipe book was released in April.  This is
a cookbook style book for experienced SSRS designers...

Dynamically Adding and Removing Columns to a Query and Report

Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...

How to parameterize a TOP values query

There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement.  Consider the followong attempt...

Return the Value of a Specified Dataset Row Outside a Data Region

I want to return the field value for a specific row to a textbox below a table in
my report. To...

User is prompted to login when viewing a report

A user has been added to a SSRS role for the report folder or report but is still
prompted to login....

SPB Applications for Windows Mobile

<<placeholder>>

…for product review

Weblog by Paul Turley and SQL Server BI Blog.

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

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