I'm using Reportviewer control on the web page , in the properties of this control, I need to set the Server Report URL and Report Path... How to find down this info?

Thanks

In Team Foundation:

Your report server url will be: http://<Report Server>/reportserver

The Report URL will be: /<Your Project Name>/<Report Name> (i.e. /MyProject/Bug Rates)

The <Report Server> can be found by right clicking on "Reports" in the "Team Explorer" pane and selecting "Show Report Site...". Also by selecting Team => Show Report Site... (from the main menu bar on VS).

Nick,

Thanks for your response.

I have one more question, Where do I get the list of the Report name (Bug Rate, Remaining work, etc...)? Is there any API function to do that or I have to go to the TFSwarehouse DB table and query them out myself? If i have to query them myself, do you which table should I use.

Thanks you

Hi ddee,

The reports are hosted in the SQL Reporting Server and you can use the API they provide to get the list of reports in a given project and you can also get information about the reports. In fact you can run reports through the API and get back XML representation of the result and much more. Team Foundation server doesn't provide an API to do this and the list and names of the reports are not stored in Team Foundation tables.

Thanks.

Federico

Hi Federico,

Thanks for your response.

Can you tell me  Which API function that  I can use for this task? 

Thank you,

Ddee

Check out the ReportingService2005 class.

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.aspx

The FindItems method will get a list of everything from your Report Server.

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.finditems.aspx

For more info on how to get the ReportingService2005 "object" see:

http://msdn2.microsoft.com/en-us/library/ms154052.aspx
and
http://msdn2.microsoft.com/en-us/library/ms155134.aspx

Let me know if you need additional information.