InfoPath Dev

 This should be pretty easy, actually - this is something InfoPath does well. Why don't you attach your form under the Options tab (or a sample form that shows the issue) and I'll give you a hand with it?

 I think you could do this with layout tables? I've attached a simple sample form. Right click the link in the heading of this post. Save the file locally. Right click the saved file and select Design to open in design mode. From there you can preview.

 This is most likely some logic in the form - either default values or rules - that is changing the values.

 So - you'd just need to do a report (dashboard) form that queries the list the initial form submits to. You can query for just the site they have access to (or add the other filters you mentioned earlier for people who have access to all sites). Then you can use XPath to aggregate the data. See attached for an XML based sample of what I ...

Wonderful, glad it worked!

I added a default value to the main data source field UserEmailIDs that should concatenate all the users from your secondary data connection?

 Can you check the main data source field in this copy - I've added a default value that I think will do what you want. Save it locally, right click and select design to open in IP, then preview. Thanks for including all the details in the sample - that was very helpful.

Can you attach your form (or a sample) under the Options tab so I can see the secondary data connection?

 For item 4, will Supervisors be looking at one drill at a time? Or an aggregate? Generally, I'd use a couple forms for something like this. Due to your viewing restrictions, I'd probably create a regular (library) form and have it submit data to a SharePoint List, using UDCX for permissions as I initially mentioned. No ...