TechEd session: Tips and tricks for building rich reports

Here’s a recording of my TechEd 2012 North America session last week in Orlando: Tips and Tricks For Building Rich Reports The entire session is based on Report Builder 3.0. All content is relevant to both SQL 2008 R2 and SQL 2012. Topics covered: Use a tablix to organize data how you want it Use…

2

When and why the primary entity changes when using a report model

Got a few questions lately on this subject, so I thought I’d post some additional info that may be helpful. First, a few related links that may be partially helpful: The philosophy behind Report Builder data navigation (blog post) Exploring the Primary Entity and Its Related Data (MSDN) Using that little checkbox in the Report…

0

What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Most people using Report Builder 2.0 with a report model soon ask the question, what is that extra column I get back with strange values like “AC8AAAA=” in it? Answer: It’s an entity key value. If you’re going to create a group on that entity in your report, you should use this field as the…

7

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 sales” is a typical slice-and-dice filter, because it just eliminates detail or…

2

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 value of a particular field. The type of group they get…

4