Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Report Design   (RSS)
Friday, July 31, 2009 5:09 PM

Add Excel-like "color scale" conditional formatting to your reports

I’ve been meaning to do this for a long time, and it looks like David Lean beat me to it earlier this year by posting an incredibly thorough four-part discussion of how to do conditional formatting in Reporting Services . I’ve played with his sample code
Posted by bobmeyers | 1 Comments
Attachment(s): ColorScales.vb.txt
Thursday, March 05, 2009 7:45 AM

How to build a Clickthrough link in Report Builder 2.0

As I mentioned in a previous post , due to resource constraints in this release, Report Builder 2.0 is not a strict superset of RB 2005/1.0. One of the features missing from RB 2.0 is automatic creation of Clickthrough links . You can still get them,
Posted by bobmeyers | 1 Comments
Attachment(s): GetModelEntityIDs.zip
Friday, September 28, 2007 7:06 AM

Filtering on totals in Report Builder

Since releasing Report Builder almost two years ago, we've found that many users run into difficulty at some point with filtering on totals . A classic example of this is, "show me a list of customers with more than $5000 in Accessory sales." "Accessory
Posted by bobmeyers | 2 Comments
Attachment(s): Filtering on totals - Examples.zip
Wednesday, December 20, 2006 3:55 PM

Getting grouping right in Report Builder

One thing Report Builder users need to be aware of when building a report is the difference between an entity group , which displays exactly one instance for each row in the underlying table, and a value group , which displays one instance for each distinct
Posted by bobmeyers | 4 Comments
Filed under: ,
Thursday, September 28, 2006 6:02 PM

How to get RB to load a report created in VS Report Designer

Loading an arbitrary Report Designer report in Report Builder is not supported in SQL Server 2005. However, if you are trying to make it work for some reason, here are a few tips: - Don't use page headers or footers - Don't use rectangles or lists - Only
Posted by bobmeyers | 0 Comments
Filed under:
Sunday, March 26, 2006 3:57 AM

Using RDL expressions in Report Builder

While not a documented feature, you actually can enter an arbitrary RDL expression into a textbox in a Report Builder report. For example, you could add a textbox that shows the date the report was run by setting the value of the textbox to the following:
Posted by bobmeyers | 13 Comments
Filed under: ,
Thursday, March 16, 2006 4:15 AM

Adding parameters (prompts) to a Report Builder report

You easily can add basic parameters to a Report Builder report using the Filter dialog. For example, to let the user choose which year to view sales data for, add an Order Year filter condition to your report filter, then, instead of specifying a value,
Posted by bobmeyers | 4 Comments
Saturday, October 15, 2005 7:10 AM

The philosophy behind Report Builder data navigation

The top part of the Explorer pane in Report Builder is probably unlike anything most people have ever used. It starts out as a flat list of entities -- big "things" in your database like Customers, Orders, Products, etc. -- but then rearranges itself once you've added the first field to your report into an auto-collapsing, recursive tree. What's really going on here? Why the new-fangled interface?
Posted by bobmeyers | 6 Comments
 
Page view tracker