SSRS SDK with PHP rendering issue with huge data output in excel format


I downloaded the ssrs sdk for php from this site and uses it for generating ssrs reports. But it has problem with generating huge data output in excel format. If row counts exceeds 65356 the output fails. This sdk is generating output in excel 1997-2003 worksheet format and hence the issue. Excel 2007 onwards supports up to 10 lacs rows. How can i make sdk render output in latest version excel ? Can anyone help me ?


myduke wrote May 18, 2015 at 10:03 AM

That is a limitation of Excel and not the SSRS SDK.

If you're using SSRS 2012 or higher, modify the GetFormat function in SSRSReport/bin/RenderType/RenderAsExcel.php and return EXCELOPENXML.
public function GetFormat()
    return "EXCELOPENXML";
This will use the Excel 2007+ versions (.xlsx)