March 13, 2014 at 4:18 pm
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.
Facey
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy