Spent hours and hours working on the display output for the advanced invoice sub inventory search results. Some of the time was formatting and some of the time was testing with some live data. The corporation that I was testing the pages on was huge. Here are some rough stats:

46,026 records for a 30 day period.
The spreadsheet amounted to 108 MB (that is huge for spread sheet)
It took 11:37 minutes for the system to build the spreadsheet
Excel couldn't even over the 108 MB file. I waited almost 20 minutes and it still couldn't open it.
They have 74 sub attribute filters. When grouped by attribute name, it comes to 40 sub attributes (grouped)
A different stat - for 35,074 records (slightly different search), that was 2,365 unique packages

Anyways, here is what I found. The web view, with pagination, ran pretty fast. The export to Excel was as slow and big as cold honey. We need to provide more general stats, totals, groupings, and different report types. We need to show the stats - such as total quantity, total package count, total item count, totals on cost, quantity, and price. Lots of quick info vs 46,000 records. Nobody wants to look through that much data. I think that they are more interested in groups, totals, and other stats.