How do you pass in SQL Server report parameter values through a TFS Project Portal Dashboard web part?

Question

The default burndown reports displayed on the portal project dashboard start and end dates do not match the active iteration start and end dates, and the tasks reported on in the burndown are not confined to the active iteration. 

I can go to the report itself and input the proper dates and iteration number to generate the correct report. But, I want to be able to pass in these parameters from the web part configuration.  How do I do that? Note: I'm not a SharePoint expert.

---

Bob Hardister

Answer 1

See http://www.ewaldhofman.nl/post/2009/06/01/Add-SSRS-report-as-dashboard-to-sharepoint.aspx

---

Ewald - Please remember to mark the replies as answers if they help.


Blog: www.ewaldhofman.nl

Answer 2

Thanks Ewald! I'll give it a try and report back

---

Bob Hardister

Answer 3

See http://www.ewaldhofman.nl/post/2009/06/01/Add-SSRS-report-as-dashboard-to-sharepoint.aspx

This is not working in 2010 beta 2. Do you have an update on what to change?
Thanks
/Roger

Answer 4

OK, I got it to work. The 2010 schema has changed. You can use the SQL Server Mgmgt Studio to access the metadata and query the tables. 

For the Task Burndown chart, here's the command that worked in a browser:
http://{your tfs sql svr rpt server}/Reports/Pages/Report.aspx?ItemPath=%2fTfsReports%2fDefaultCollection%2fCcMsd1.0%2fDashboards%2fBurndown&rc%3atoolbar=false&rs%3aCommand=Render&IterationParam=[IterationName].[ParentIterationSK].%26[17]

Here's the comand that worked in the project portal web part:
/sites/DefaultCollection/CcMsd1.0/_layouts/TfsRedirect.aspx?tf:Type=Report&tf:ReportName=Dashboards%2fBurndown&tf:ShowToolbar=0&Width=381pt&Height=180pt&tf:Command=Render&tf:Parameters=IterationParam=[IterationName].[ParentIterationSK].%26[17]

I will be posting this and more of my work on team portal/web part customization on http://agilescmtalk.com/

Bob

---

Bob Hardister