Connection error after copying an rdl

Whenever I make a copy of an existing report (.rdl) in order to use it as a
template for a new report, I get the following error message when I try to
preview it:
An error has occurred during report processing.
Cannot create a connection to data source 'Prospect'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
The originial copy of the report - in the same project - works without
error. Why is this happening. This requires me to start every report from
scratch, and since I have a lot of parameters and data sources, this is very
tedious.Since specific credential information is not stored in the .rdl so when you
attempt to preview the copied report you'll see this error until you modify
your report DataSource. If you modify your report DataSets to use a shared
DataSource, I don't believe you'll run into this.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jody Z" <Jody Z@.discussions.microsoft.com> wrote in message
news:B95FFD30-F0D5-4FAC-B6C9-6A91DD5DFAA0@.microsoft.com...
> Whenever I make a copy of an existing report (.rdl) in order to use it as
> a
> template for a new report, I get the following error message when I try to
> preview it:
> An error has occurred during report processing.
> Cannot create a connection to data source 'Prospect'
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL
> Server connection.
> The originial copy of the report - in the same project - works without
> error. Why is this happening. This requires me to start every report
> from
> scratch, and since I have a lot of parameters and data sources, this is
> very
> tedious.