Bob's SQL Reporting Services Blog

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

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 group...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (5 items)