is there code in the report - the error might indicate the code is stuck in a loop somewhere, eg a non-terminating for ... next loop or something which eventually uses all your available RAM memory
alternatively, the query (report) might just be too complex - but you would probably get a different error in that case