Hello, I'm having trouble exporting data to Excel.
I have three matrices on this report, each of them contains multiple row groups and page is set to break at the end of the first row group.
The desired outcome is to export the entire report to Excel, with data from each row group in separate sheet. But I'm encountering the following error:
"Operation is not valid due to the current state of the object."
I don't want to confuse anyone, but the strange thing is that the report exports successfully if I remove objects containing expressions from the header and footer. This can be a potential work around, but I would like the header and footer to repeat on each sheet if possible.
Any help is appreciated.