A client wants 10 salespeople to be able to view one-day-old receivables information, each salesperson looking at their specific customers only. The report could be a PDF or an Excel spreadsheet. They have created a folder for each salesperson on their server, and that's were they would like each report sent.

They want the reports updated "automatically" every evening. They are comfortable using Task Scheduler.

I know I can use GridView to generate the report, and build 10 filters, one for each salesperson. But how can I have it "automatically" create 10 Excel spreadsheets, each in a different folder depending on the filter.

I might add that it takes a few minutes to recalculate the GridView, so the fewer recalcs needed, the better.

Not as critical, but they have two sister companies, with shared salespeople. It would be ideal if each salesperson's report contained two customer lists - one for each company. In Excel this would mean two separate sheets. If this is not feasible, they are OK with getting two separate reports.

Thanks for any suggestions you might have, especially if they involve GridView functions I am not familiar with.

Steve