Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export to Excel Error: Matrix and page break at row group Expand / Collapse
Author
Message
Posted Thursday, March 13, 2014 4:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 4:28 PM
Points: 1, Visits: 1
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
Post #1550951
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse