Things to try:
- Check that the user running the report has execute permissions on any stored SQL procedures called in the report (if any)
- Compile the report against the same instance it is being run against. (If it is compiled against other instance, and that instance is somehow different to the one it is running on, this error can raise).
Hope this helps.