Sounds like a job for whoever created the front end for you.
If it functions on 3 machines, and other reports function on the 4th but not this one, I'd suspect a missing DLL that the report is using that other's are not, such as grqaphing, etc.
The above whitepaper describes that error reasonably well, there are a myriad of possible problems, including MDAC, wrong ODBC, etc.
-k