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