Hi, 1) Open the Report builder link from Report server. 2) Select the required Model name from right pane. 3) Model opens in "Design Report" mode. 4) On left pane, in "Entities" pane assume there are list of tables/views. 5) Double click on any one view, so that you can child values. Issue is, after we drill down how to get back to the list of initial tables/views back in the same panel. Can anyone help me solve this? -Sahana

Hi Sahanakr, Generally, when we add an entity to the design area by double-click it or drag the entire entity, the entity becomes the primary entity. In other words, that entity becomes the focus of the report. And, the Entities list displays only the primary entity and the entities that share a role with it. As we might know, query two unrelated tables results in a Cartesian join that returns all the rows in the two tables where each row in the first table is paired with all rows in the second table. To avoid this, the Report Builder guides the user to select related entities only. However, it will get back to the initial views by click Undo icon on the tools bar, which will drop whatever you have done. For more information about primary entity, please refer to: http://msdn.microsoft.com/en-us/library/aa337232(v=sql.100).aspx. Any questions, feel free to contact me. Thanks, Lola Wang Please remember to mark the replies as answers if they help.