More Information:
The problem is demonstrated by the following part of the error message: Invalid object name 'cognos.crdConnectedUsersSub'
The report is looking for a table 'cognos.crdConnectedUsersSub' when in fact the table's name is 'dbo.crdConnectedUsersSub'