Data missing in a crosstab after a fixed amount of rows

[Fea]

Hello, i'm having a problem concerning cognos 11.0.13.
One of my user has a report with a crosstab that contain a great amount of data and he noticed a problem starting at row 45001 (on excel) where data start going missing in a stair like way and come back in the same way after a few thousand rows.


To try and solve his problem, I increased the parameter RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE to 150000 which pushed the problem to row 650001.I Increased this parameter again to 300000 but the problem stayed at row 65001.

These numbers feel odd and i wonder if another parameter could be the cause.


Thank you in advance for your insight

[adam_mc]

Try setting the following - You may need to restart services for these to take effect:

RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS - 1000000
RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE - 1000000
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET - TRUE

This is what we have our relevant setting set as.
Hope this helps,
Adam.