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…


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….

7