Hi everyone!
I am having an issue when I try to export my report to Excel.
I have implemented page breaks using this iif statement in a group on the report:
=Int((RowNumber(Nothing)-1)/40000)
This works perfectly the first time I go to export the data. It splits the data into two sheets and works just great.
However, if I try to export the same data to Excel again, the report times out in SSRS(and SharePoint), giving me an OutOfMemoryException.
Are there any particular reasons why this happens?
Thanks in advance for your help!
Edit: I am using BIDS for this. Sorry, forgot to state that.