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

Deploying a report

I am new to Reporting services and have created just a layout page.

no datasets or data sources are present. This is just a cover page.

I need to show this page through a url. Can i deploy this on my local machine rather than showing some-one through the preview mode.

What would be the local host configuration settings.

Thanks.

Do you have the report catalog databased and report server installed on your local machine?

If so and you'd like to deploy from visual studio, go to your project properties, find the target url property and put in "http://localhost/reportserver". Next right click and try "Deploy".

You can also easily deploy from SQL Server Management Studio.|||

Hello,

I dont think I have the reportserver installed on my machine.

When i try doing the localhost/reportserver it shows an error saying underlying connection failed.

I tried deploying from SQL server management studio trying bto make sense of the $MYSORIAN. that failed too http://aspalliance.com/819

Any help documentation etc?

thanks

|||

Hi, I assume you are using BI to build your report. If so, right click on the project and select properties and setup Deployment parameters as follows:

TargetReportFolder TestReport (your report folder name if you want to store the report in a separate folder other than

default Home folder)

TargetServerURL http://ReportServerPC/ReportServer(If the report server was installed using default settings)

or

http://ReportServerPC/ReportServer$NameoftheReportServer(If the report server was installed as named instance)

For example if the name of your report server instance is ABC and it was installed on a server 123 then it would be

http://123/ReportServer$ABC

Please note you have to use https, if the report server is configured to use SSL.

After setting up the parameters, right click on your report and select deploy.

Hope this helps!

|||

Hello,

In this setup how would i be able to replace local host. I do not know if the ReportServer is installed on my machine and i do not ahve access to any other server.

TargetServerURL http://ReportServerPC/ReportServer(If the report server was installed using default settings)

Thanks

|||

Hi,

There are couple ways you can check whether you have report server on your machine or not.

Check your program files folder: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services Check in your IIS management console whether you have a virtual directory called ReportServer under default website Copy the url http://localhost/ReportServer paste into your web browser and if you can see the folders in ReportServer web folder then you have reporting services on your PC.