Project 2007 with Sql server 2000 reporting

[Ashish kanoongo]

hello

How to integrate Sql 2000 reporing services in Project server 2007. I have
huge project server 2007 database in Sql server 2000. I want to create some
reports using existing sql 2000 db, I want to know how do I to publish
sql reporting 2000 report in project server 2007?

Ashish

 

[James Fraser]

hello

How to integrate Sql 2000 reporing services in Project server 2007. I have
huge project server 2007 database in Sql server 2000. I want to create some
reports using existing sql 2000 db, I want to know how do I to publish
sql reporting 2000 report in project server 2007?

Ashish

You have two options:
1) Place links to the reports into PWA or a link to /reportserver/
or
2) Add a Webpart to your PWA pages that displays reports. For more
information on this, use the instructions here:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
(So this is really more of a Reporting Services and SharePoint issue
than Project Server.)


Hope this helps...
James Fraser