Unable to Access Reports on Remote Servers
You cannot access a report in Microsoft Excel format on a remote server.
To resolve this problem, you must change the hostname portion of the gateway URI from localhost to either the IP address of the computer or the computer name. You do this using IBM® Cognos® Configuration.