Report looking at wrong (old) data source

Hi,
I've changed some reports to use a different data source. To do so I
created a new shared data souce called ReportsTest, and changed the
data source for some reports to now point to ReportsTest instead of
the original Reports data source. However I am getting the following
error.
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'Reports'.
(rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied.
It's as if the report is still trying to use the original data source
for some reason' It still exists, but I want this report to use the
other data source that I've created. Why is this happening and how
can I fix it'Sorry, just hoping to get some feedback on this. If a report has to
use a particular data source does this data source have to be created
in the report designer and linked to the report here?
Is the name of the data source used by a report hardcoded into the
.rdl file of a report somehow, and not able to be changed in the
report manager'
gearoid_healy@.yahoo.com (Gearoid) wrote in message news:<3d6ebe80.0411050413.1fc8bcfb@.posting.google.com>...
> Hi,
> I've changed some reports to use a different data source. To do so I
> created a new shared data souce called ReportsTest, and changed the
> data source for some reports to now point to ReportsTest instead of
> the original Reports data source. However I am getting the following
> error.
>
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'Reports'.
> (rsErrorOpeningConnection) Get Online Help
> SQL Server does not exist or access denied.
>
> It's as if the report is still trying to use the original data source
> for some reason' It still exists, but I want this report to use the
> other data source that I've created. Why is this happening and how
> can I fix it'