How does one deploy reports from VS (05) to Project Server?

[Andrew `Taersious` Coppock]

I have a Report Pack that I obtained from MS and have gone through the
documentation about how to set up a project in VS. Everything worked as
expected in setup, and I've edited the data source correctly. Now I try to
deploy using the >Build >Deploy tool bar item. The project builds
successfully, but tries to deploy to a path like http:
//<servername>:<portnumber> - I do not know where this is defined, whether in
SharePoint or PWA configuration. Any pointers, web documentation, or direct
solutions from experts would be greatly appreciated at this point.

Here's my output from VS:
Build complete -- 0 errors, 5 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

 

[Chak]

I have a Report Pack that I obtained from MS and have gone through the
documentation about how to set up a project in VS.  Everything worked as
expected in setup, and I've edited the data source correctly.  Now I tryto
deploy using the >Build >Deploy tool bar item.  The project builds
successfully, but tries to deploy to a path like http:
//<servername>:<portnumber> - I do not know where this is defined, whetherin
SharePoint or PWA configuration. Any pointers, web documentation, or direct
solutions from experts would be greatly appreciated at this point.

Here's my output from VS:
Build complete -- 0 errors, 5 warnings
========== Build: 1 succeeded or up-to-date, 0 failed,0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

Hello Andrew,

On your VS Project explorer, right click on VS Project Name , you will
see the properties window.
Please make sure you have correct TargetServerURL. TargetServerURL is
the mail URL of your Report Server.

Thanks
Chak
http://www.epmcentral.com

 

[James Fraser]

I have a Report Pack that I obtained from MS and have gone through the
documentation about how to set up a project in VS. Everything worked as
expected in setup, and I've edited the data source correctly. Now I try to
deploy using the >Build >Deploy tool bar item. The project builds
successfully, but tries to deploy to a path like http:
//<servername>:<portnumber> - I do not know where this is defined, whether in
SharePoint or PWA configuration. Any pointers, web documentation, or direct
solutions from experts would be greatly appreciated at this point.

Here's my output from VS:
Build complete -- 0 errors, 5 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

The Report Pack is for SQL Server Reporting Services (SSRS or SRS.)
SSRS needs to be installed somewhere to deploy these reports,
typically, on the SQL server. During the configuration of SSRS, you
will configure a new web site to host reports.

The reports read Project Server reporting information, but don't
deploy to Project server, they deploy to the SSRS web site.


Hope this helps...
James Fraser

 

[Andrew `Taersious` Coppock]

Thanks, Chak.

I was able to do that; however, the setting that needs to go there escapes
me. Where its that configured? We have a 1 server farm currently, and the
Central Administration settings do not offer a TargetServerURL setting that I
can find. Is that done from PWA?

 

[Chak]

The Report Pack is for SQL Server Reporting Services (SSRS or SRS.)
SSRS needs to be installed somewhere to deploy these reports,
typically, on the SQL server. During the configuration of SSRS, you
will configure a new web site to host reports.

The reports read Project Server reporting information, but don't
deploy to Project server, they deploy to the SSRS web site.

Hope this helps...
James Fraser

Thanks James.

Andrew: As James mentioned, I assume you already have SQL Reporting
Services installed. If not, please do. Once your SRS configured, you
have to use the step I mentioned in my previous posting (specify
Report Server URL as targetserverURL on your VS Project)

Thanks
Chak
http://www.epmcentral.com

 

[Andrew `Taersious` Coppock]

Thanks, Chak.

Upon further investigation, there were no SSRS directories under
c:\progra~1\sqlserver\mssql.x -- so I am about the business of installing and
configuring that. I assumed they were as well, since I was not the admin to
install SharePoint or PWA.

 

[Chak]

Thanks, Chak.

Upon further investigation, there were no SSRS directories under
c:\progra~1\sqlserver\mssql.x -- so I am about the business of installing and
configuring that.  I assumed they were as well, since I was not the admin to
install SharePoint or PWA.

Hello Andres,

You got it.

Many of them confusing by seeing the SRS Reporting pack and getting
impression that those reports will work with PWA.
I am reiterating what James said on this discussion, SRS Report pack
is a complimentary we are getting with MS Project Server 2007. SQL
Reporting Services is not integral tool of MS Project Server. It's an
optional.

Project Server 2002/2003: Windows SharePoint Services and SQL
Reporting Services are optional

Project Server 2007: MOSS and SQL Reporting Services are optional


If your organization wants to have Project Server reports, so it's
your turn to install and configure the SRS on your SQL Server or on
another machine. Once you configured SRS Report Server, you have to
create the Visual Studio Project
and add those complimentary SRS Reports and point the data source to
your project server reporting database. By specifying the SRS Report
Server URL, you have the ability to deploy reports and view those on
browser.

As I said, SRS is an optional. You can use any reporting tool like
Crystal Reports. Crystal Xcelsius, Cognos or Business Objects. Just
you have to define the data source pointing to Project Server
Reporting database, and then you all set for reporting. Have you seen
Crystal Xcelsius? It's have powerful features on Project dashboard
reporting.


Why SQL Reporting Services?

Answer is:

SRS can install on SQL Server. (Anyhow you already have SQL Server
when you have MS Project Server)

You are getting the Report pack with MS Project Server 2007. If you
are using the reporting tool, you have to redevelop those reports
again.

You will cover SRS license cost with SQL Server. If you are using
another reporting tool, you have to spend additional cost for
reporting tool.

Again on top of those, we are all Microsoft family

Good luck.


Thanks
Chak
http://www.epmcentral.com