Hi,

in our current project we have a number of usergroups that are not permitted to see the information of another group. So each usergroup has its own SharePoint site with a SharePoint list containing the user information. Normal users are restricted to one SharePoint site, but managers are allowed to acces all lists. All lists have the same structure - the same name, the same fields, etc.. (but a different URL)

When integrating reports we planned to simply create one report that should gather information from all SharePoint lists (that have the same name, structure, etc). Everybody (manager and normal user) should be able to execute this report. You should not get an error message telling you that you has limited/not the full rights. Data, that you are not allowed to see in SharePoint, should not be displayed in the later report, but you should see all your data for which you have access rights in SharePoint.

For us this is an very essential scenario when using the rollup list feature.