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: A better way to model inheritance

    I've been playing around with a report model we use internally here in the SQL Server product group. At a conceptual level, the data being modeled makes heavy use of inheritance (EntityA "is a" EntityB), but in working with the model and with Report Builder, I'm finding some significant advantages to...
  • Blog Post: Creating a role to one of several related items

    I call this the Primary Address problem, because a classic example is when you have a Customer table and an Address table, and each customer can have many addresses (Primary, Billing, Shipping, etc.), but no more than one of any given type. If you have a FK constraint defined, the report model wizard...
  • Blog Post: Evolving your report model over time

    Many factors combine to make report models highly likely to change and evolve over time. Sometimes the underlying schema changes. Sometimes new stuff is added. Sometimes you just want to improve how the schema is presented to users. Report models are designed to accommodate just these kinds of changes...
  • Blog Post: How to create a 'company' security filter for a hosted application

    Several customers have asked how to restrict data visibility in a report model for a hosted application, where every table has a "CompanyID" column, and every user that accesses the system is associated (via some other table) with exactly one company. The straightforward solution is to create a security...
  • Blog Post: Collapsing a many-to-many relationship in a report model

    Often a many-to-many relationship exists between two entities where the intermediate entity has nothing on it except the connecting roles. For example, it might be that an Employee can be assigned to many Regions, and each Region can have many Employees assigned to it, but there is nothing interesting...
  • Blog Post: Report model denormalization: Why, How, and When

    Relational databases are often heavily normalized to improve performance, reduce storage requirements, and ensure data consistency. While performance may be relevant to report execution, neither of these reasons is relevant when presenting the schema to an end-user at design time. Hence denormalization...
Page 1 of 1 (6 items)