I have a report that lists items purchased by various customer accounts. To allow for a better user experience, I've suppressed duplicate data on repeated lines. I've come to learn that a handful of our clients are going to need the ability to export that data as well. With the report designed how it is, that would require a LOT of copy and pasting (or a nasty formula in Excel) to fill in the gaps. Look at the included screen shot. It shows how I only list the customer name once on the report per order. By the way, banding exists on this report; any gray backgrounds only represent a change in the customer record.
Is there a way to have the report export the data as if I had never turned on the "Suppress Duplicate Records" feature? In other words, can I have the report conditionally skip that feature if it's being exported? ....I'm also open to alternative strategies with this too.