CR2008: Cross-tab export to excel repeating column headers

I've exported a cross-tab to excel (开发者_Go百科NOT data-only) and noticed that after every so many rows, it automatically repeats the column headers.

This makes it difficult to sort and filter. I don't understand why the column headers are being repeated, and there doesn't seem to be an option to disable this.

Anyone run into this issue before and managed to resolve it?

EDIT: it appears that crystal is automatically adding page breaks to the export. One solution I've found is to dissociate page size from printing page size, and then set the vertical length to be ridiculously large. Of course, the page size is still hardcoded so with sufficiently large amounts of data, the solution would still not work, but fortunately I have upper bounds on just how large the data set can be.

Did you set these Excel export options?