Bob's SQL Reporting Services Blog

Notes, tips, rants, and ruminations on SQL Reporting Services, and Report Builder in particular.

Sometimes you have a short list of values that you really don't want to show on individual rows;...

Date: 06/18/2012

Here's a recording of my TechEd 2012 North America session last week in Orlando: Tips and Tricks For...

Date: 06/18/2012

Got a few questions lately on this subject, so I thought I’d post some additional info that...

Date: 02/27/2012

I’ve been meaning to do this for a long time, and it looks like David Lean beat me to it earlier...

Date: 07/31/2009

Reports and report models can be localized at many levels. Following are some ideas around the...

Date: 04/27/2009

Customer report models that vary in size from a few to a few hundred entities. Little Northwind with...

Date: 04/27/2009

SQL Server 2008 SP1 is now available, and includes some important updates related to Report Builder...

Date: 04/08/2009

Report Builder 2.0 makes it easy for business users to browse for and use centrally-defined and...

Date: 03/28/2009

Most people using Report Builder 2.0 with a report model soon ask the question, what is that extra...

Date: 03/06/2009

Are you using a report model in your organization? The Reporting Services product team wants to hear...

Date: 03/06/2009

As I mentioned in a previous post, due to resource constraints in this release, Report Builder 2.0...

Date: 03/05/2009

I've been playing around with a report model we use internally here in the SQL Server product group....

Date: 03/05/2009

Just a quick post to answer the inevitable question when those familiar with Report Builder 2005/1.0...

Date: 03/05/2009

In SQL 2005 the semantic queries generated by Report Builder do not support sorting. This is not a...

Date: 10/11/2007

Since releasing Report Builder almost two years ago, we've found that many users run into difficulty...

Date: 09/28/2007

Some customers have report models that are large enough they do not expect any user to ever request...

Date: 02/27/2007

A number of people have asked if it is possible to launch RB from the command line. While it is in...

Date: 02/22/2007

The Filter dialog in Report Builder has a little checkbox near the bottom that many users have asked...

Date: 01/15/2007

I call this the Primary Address problem, because a classic example is when you have a Customer table...

Date: 12/20/2006

In this release of Report Builder there is no direct support for referencing parameters in the...

Date: 12/20/2006

One thing Report Builder users need to be aware of when building a report is the difference between...

Date: 12/20/2006

Huge new feature: integrate your RS 2005 report server with SharePoint 12! What's new in SP2?...

Date: 11/10/2006

I've attached a sample C# project illustrating how to create a custom data processing extension...

Date: 10/31/2006

Many factors combine to make report models highly likely to change and evolve over time. Sometimes...

Date: 09/28/2006

Sometimes it is useful to create a report model that can be used against multiple databases that...

Date: 09/28/2006

Clickthrough reports are the special kind of drillthrough reports created by Report Builder. They...

Date: 09/28/2006

Loading an arbitrary Report Designer report in Report Builder is not supported in SQL Server 2005....

Date: 09/28/2006

Report Builder uses a client technology called ClickOnce to download and launch the application...

Date: 09/28/2006

...and one of my esteemed colleagues, to boot. :) https://blogs.msdn.com/chrisbal/

Date: 07/10/2006

There are two ways to get the generated SQL for a Report Builder report (or for a model-based query...

Date: 07/05/2006

Many people are interested in creating subscriptions to Report Builder reports. In SQL Server 2005...

Date: 03/30/2006

While not a documented feature, you actually can enter an arbitrary RDL expression into a textbox in...

Date: 03/25/2006

Several customers have asked how to restrict data visibility in a report model for a hosted...

Date: 03/24/2006

Often a many-to-many relationship exists between two entities where the intermediate entity has...

Date: 03/24/2006

I just posted the first article on my blog. Here's the abstract: The report models introduced in SQL...

Date: 03/18/2006

The SQL Server 2005 SP1 CTP is now available. This update fixes a number of Report Builder issues in...

Date: 03/18/2006

The report models introduced in SQL Server 2005 feature a number of ways to customize the data...

Date: 03/18/2006

You easily can add basic parameters to a Report Builder report using the Filter dialog. For example,...

Date: 03/15/2006

To launch Report Builder, use one of the following URLs (also documented on MSDN):...

Date: 01/24/2006

IT People and Report BuilderThe natural inclination when IT people see and start to use Report...

Date: 01/20/2006

Relational databases are often heavily normalized to improve performance, reduce storage...

Date: 01/19/2006

SQL 2005 report models will ship with a curious and admittedly incomplete solution for handling "the...

Date: 10/25/2005

The top part of the Explorer pane in Report Builder is probably unlike anything most people have...

Date: 10/15/2005

Here's a neat trick a co-worker and I discovered this afternoon for creating an inline bar chart (an...

Date: 10/15/2005