data linked from sharepoint does not work from remote network

[elbyc]

I have a report which is based on queries of a linked sharepoint list.
It works great when I'm in the office, but when I dial in from a
remote server (LAN connection) I get an error saying the Record source
cannot be found for one or two of the subreports (not always the same
ones). Also it says the an error occurred while sending data to the
OLE server.
I suspect this is a memory issue, but is there a way to troubleshoot?

 

[elbyc]

I have a report which is based on queries of a linked sharepoint list.
It works great when I'm in the office, but when I dial in from a
remote server (LAN connection) I get an error saying the Record source
cannot be found for one or two of the subreports (not always the same
ones). Also it says the an error occurred while sending data to the
OLE server.
I suspect this is a memory issue, but is there a way to troubleshoot?

Ok - I dug around a bit and found that the error was due to over
complexity of one of my subreports. It was a bit odd since the chart
affected was in a different subreport, but I was able to correct by
changing the query for the offending subreport from a union query to a
regular select query.

 

[rich]

I have a report which is based on queries of a linked sharepoint list.
It works great when I'm in the office, but when I dial in from a
remote server (LAN connection) I get an error saying the Record source
cannot be found for one or two of the subreports (not always the same
ones). Also it says the an error occurred while sending data to the
OLE server.
I suspect this is a memory issue, but is there a way to troubleshoot?