InfoPath Dev

Hi First i want to thanks the experts here which the posts helped me a lot on setting up my form. I'm creating a form which is used to track the employee expense information. It has common section which includes event date, type of expense etc. And on the repeating section, it allows employee to enter the expense details per clients ...

 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!

 Mystery solved.  The reason your modified form was giving me blanks was because I had not removed all that form load code I put in. So it stuck blanks over the top of your default value code. It works! Your code is majak! :)    Thanks again... Ray

For #4, ideally I would like to show the aggregate for each type of drill (with a total number of each drill) and then be able to click a + sign and show the detail for each. Site A  -  Fire Drill               3       Fire ...

 Haha! I was looking all over the datasource area but never thought to look at the receiving field default. DUH! I need some more "Anti-Monday dummy" coffee! I have previewed it and it is giving me blanks right now, but you have given me a solid base to work from troubleshooting it.    You should either marry me ...

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

hmmm... I guess i'm not as smart as I thought I was. I clicked on the link in the header, and downloaded that file, however, I cannot see any changes in the data source. Where do I look? I clicked on the "Data Connections" in the Data tab and when through the options on the ParameterList under "Modify" and did not ...

 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.