Your solution would work, but it would require several steps. The reason we export the report to Excel is it already exists. In other words, users are already looking at the report. so what do we do? Add another button to the selection criteria instead of preview to export. Then they have to look at the report. Close the report. Run the query again. That will not go over well. Users generally do not like to have an extra click added to every step of thier workload. So adding two extra clicks AND a wait for a query is going to make everyone who uses this function unhappy.
So while your solution technically works, it comes up short in a business sense. Not your fault since you didn't have all the details, but thanks for trying.
Remember these are the same users who complained about seeing the quotes. While your solution fixes this, it introduces more work.
I mentioned to them I could write my own export routine. Its not very hard to copy query results to Excel. I can just populate a dataset. ADO has functions to do just that. But then they have to learn a new way to do their job. And I don't blame them for not wanted to get used to something different. sometimes it can be difficult to see things from a user's point of view. They want it to work the way they are used to or not at all. And depending on what they do with the spreadsheet, it may be the best thing for the bottom line.