i have a few report have the following error during running in the test
server. but it was running fine when i point the db to the live server in the
same machine. in fact, the live server are having much more records then the
test server, but wondering how come the live server do not hit such error, is
it due to the SQL server version different? appreciate any1 can help. thanks

SQL server version in both server
In live server the the SQL version is
SQL server enterprise edition 8.00.760 (SP3)

In test server the SQL version is
SQL server standard edition 8.00.2039 (SP4)

Reporting Services Error
--
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'DSYearlyRpt'. (rsErrorExecutingCommand)
Get Online Help
Internal Query Processor Error: The query processor ran out of stack space
during query optimization.