Explorer Views have the ability to create summary sections for say Invoice totals for Customers. After you collapse the detail view and only see the summary sections, you want to export this 'SUMMARY' information. But when you do, it displays in Excel in detailed view. Another example is you create a view of Historical SO invoices and want a count by city, state or zip code to determine how much business you are doing in an area. You collapse the detail view to see just the summary to give you an invoice count by zip code and try to export it to Excel, but once again, all the detail shows up in Excel. Then you have to work in Excel to sort and group everything...too much work.

by: Ken K. | over a year ago | Integration