While I don't like this screen, because of its lack of drilldown, I have a client whose owner uses it daily to eyeball sales trends, by month and by year. All he really looks at are the Net Sales, Cost of Sales and Profit % rows.

The company recently opened up a second warehouse, and he would like to see the information by location.

I have tried every which way, using SalesAnalysis Inquiries and GridView, to reproduce this information for a location, without success. There is just no way to generate the information in a reasonable time frame, not with a million sales transactions, and even when generated, the presentation is not nearly as good as the standard screen.

How can I satisfy this reasonable request?

Steve