We are using cognos 10.2. I created a large report (> 804466 rows) in the PowerPlay Studio, then I exported to Excel 2007 from PowerPlay Studio. No error during the 'save as'.
The output .xlsx file is less than 1.4M, only two worksheets (Sheet11 and Sheet12). Sheet11 has 65536 rows, Sheet12 only has 6 rows and last row is: Rows 1-65536 of 804466. Rows are missing in this output file.
I tried RSVP.EXCEL.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS =true, I also changed ExcelSpreadSheetSize in rsvpproperties.xml file, none of the options work.
Does anyone run into this issue?