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

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