can't see last page of report

[madelca100]

I'm using CR 9.2.0.448 against a MS Access database via a query. The query appears to work properly in Access.

When I run my report CR opens the preview with 1 of 3 and displays the drill down on the left of the report.

When I click the right arrow to go to page 2 is show 2 of 3 but then greys out the right arrow (so I can't get to page 3!)

The drill down shows all the data in the report, but when I click on anything on page 3 it takes me to page 1.

1) I have verified the database.

2) Other reports using the same Access database but different Queries work just fine.

3) The Access query works fine in MS Access - and returns 2,263,567 records - which the Crystal report also verifies in the record count. (some of my other queries return answer sets this large, so I don't see this as the problem.)

4) If I run a subset of the dataset (like 100 records) it works fine.

5) I don't have time to run many iterations of this to see where it 'breaks'.

I am going to rebuild this report, but I would like to know if anyone else has experienced this behavior.

thanks,
mike

 

[madelca100]

Fiddled around long enough and finally resolved this issue.

Unfortunately it worked after I changed two things. (Usually I change one thing at a time so I know which one worked.)
I changed 'virtual memory paging' size to 2 meg.
And I cleaned up my 'C:' drive.

If I was a betting man I would bet that making room on the c: drive did the trick.

ciao,
mike