I have a client installation using Crystal Reports v10 SP6 reporting sales and volume figures daily/weekly and monthly year on year comparisons for more than 100 stores.
They have just upgraded the MSSQL 2000 database to MSSQL 2008 and the daily report fails with a 'Not supported' error message, on the larger brand of stores, but not on the much smaller brand of stores.
The error occurs during the 'reading record' process, where someway down this track Crystal will just come up 'Not supported', the record count resets to zero.
I'm trying to find out if is there a known condition in MSSQL Server 2008 Express Edition which trips up Crystal Reports Version 10 on large volumes of transactions. (60 million or more rows)
All help is appreciated