We are using MSP2010 and Sharepoint server, we have over two hundred projects on the server, what is the best reporting tool from MSP to query/report selected project information, for certain periods of time? Example: I want to pull project in Design Phase for a fiscal year. Any suggestions, it seems like SQL Reporting Services may be the best selection??
You probably already have all of the tools that you need. The Business Intelligence Center in PS2010 will allow you to build the reports that you need, and can leverage Excel Services, Visio Services, PerformancePoint, and SSRS.
Here’s an article to get you started: