I've accomplished this passing the filter/parameter values in the URL to another workbook, but be aware that there is a limit to the length of the URL. So if you allow multiples, your users could inadvertently "break" the workbook by trying to pass in too long a string.
Thanks for the idea Mark.
There could be thousands of customers ids/names so there's a good chance we'd hit the limit if went that route.
I hoping there is another way to accomplish this.
Is there a reason you want separate reports? You could create multiple sheets in a report but have the custom filter apply across both sheets, the other filters apply only to their respective / specific sheets.
If it has to be separate reports, you'll need to get creative with the API.
That's a good question. And if you can recommend a better way, I'd be all for it.
The requirement is this:
1) We want to have a set of filters that are used to identify a set of customers. We want to be able to filter on a number of things like product type, Order Date, Purchase quantity, sales amount, etc.
2) We want a secondary report that is all the historical details of those customers identified from step 1. This report needs to be completely unaffected by the filters from step 1 and is basically just filtered based on customer ID/customer name.