I'm designing a report that requires that I hide a group and its details so that my manager can click on the group (sales rep in this case) so that he can see the detailed sales record for the current month.  Below the Sales Rep grouping, I've created another group based on invoice number so that I have invoice subtotals.  The problem I have is that I want my manager to be able to see all the invoices, their details and the totals.  However, what's happening is that if you click (expand the group) on a Sales Rep, you only get the invoices listed and not their details, you have to click on the individula invoices again to get those detials to show. I don't want him to have to click on every single invoice and then have that pop up in new tabs.  How can I reformat this so all the details and headers show up, or non of them?

 

Thanks in advance,

 

Narmi