Deploying Reports

Hi All,
I am having a strange problem. I have created a shared data source and
multiple datasets for my reports. The multiple datasets are created to get
data for the different parameters in the report. The report works fine in
Visual Studio. But I don't see the data source listed and when I try to
deploy the report and run it on my webserver. I get the following error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CWPresales'.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on the
local server machine, or enable remote errors
Can anyone help me with this. I am confused on why I cannot see the
datasource listed in the solution explorer.
Thanks
ShriI am not sure what you mean by solution explorer? I use Report Manager for
this sort of thing. When you deploy the data sources get created BUT they
get created without credentials. You need to use Report Manager to view the
properties of the data source and set the credentials.
Data sources in RS2005 can either be in the same folder as your reports or
in a special folder called Data Sources. Just in case they are hidden in
List View then click on the Show Details link in Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"formcreator" <formcreator@.discussions.microsoft.com> wrote in message
news:44C8FFDC-B340-43E5-8244-9AAEA63902D1@.microsoft.com...
> Hi All,
> I am having a strange problem. I have created a shared data source and
> multiple datasets for my reports. The multiple datasets are created to get
> data for the different parameters in the report. The report works fine in
> Visual Studio. But I don't see the data source listed and when I try to
> deploy the report and run it on my webserver. I get the following error
>
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'CWPresales'.
> (rsErrorOpeningConnection)
> For more information about this error navigate to the report server on the
> local server machine, or enable remote errors
> Can anyone help me with this. I am confused on why I cannot see the
> datasource listed in the solution explorer.
> Thanks
> Shri