How does Crystal determine the rowcount in excel?

Hello All,

I guess this forum is primarily for LBI questions, but I have a Crystal question that I thought someone may know the answer to. Here's the question:

I have a Crystal report that I export to excel 97/2003 xls format. When the report data is exported it encompasses more than one page due to the 65536 row limitation. We have tried to upgrade to Crystal 2010 which allows to export as an xlsx file without the 655236 row limitation being encountered as with 97/2033 xls file format. Unfortunately, we were told by Lawson that Lawson version (201005) 9-0-4-1-150 01.28 which is what we currently have is not compatible with Crystal 2010.

So we are stuck with Crystal 2008. The question I have is how can I determine how Crystal tracks the excel row count? When I currently export the report to xls it includes more than one sheet of data. In the Export dialog box under the Export headers and Footers, I selected export once per report, but I would like to have the header appear at the beginning of each new sheet. The other two options are to None - neither of which serves my purpose.

In the Selection Expert for the page header I tried using the RecordNumber property thinking this would tell me the row count. But, I was mistakenly comparing apples and oranges; the two seem to be very different. My recordNumber shows 2,800,000 something records whereas the total number of rows once exported to excel is around 95K.

Does anyone know how I could control the printing of page header at the beginning of each new sheet? Any suggestions is greatly appreciated.

Thank you.

Imtiaz.