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

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

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

SPB Applications for Windows Mobile

<<placeholder>>

…for product review

Weblog by Paul Turley and SQL Server BI Blog.

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

Nested Tables in a Repeating List Data Region

Report designers often revert to overly complex report designs and often use subreports
unnecessarily. Building a report on a single dataset...

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

Using a Report Subscription with User Authentication

This question comes up quite often. A report requires a user to be authenticated using
their own network user name and...