Blog Stats
  • Posts - 65
  • Articles - 0
  • Comments - 7
  • Trackbacks - 0

 

Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal

There is some helpful information from Ewald Hofman on passing in parameters to the TFS SQL Server Analysis Services OLAP reports.

But, the 2010 schema has changed. You can use the SQL Server Mgmgt Studio to access the metadata and query the tables to seee the new schema and record values.

As an example of the Task Burndown report on the TFS 2010 Project Portal, here's the URL that worked in a browser:

http://{your tfs server}/Reports/Pages/Report.aspx?ItemPath=%2fTfsReports%2fDefaultCollection%2fCcMsd1.0%2fDashboards%2fBurndown&rc%3atoolbar=false&rs%3aCommand=Render&IterationParam=[IterationName].[ParentIterationSK].%26[{the IterationSK value}]

Here's the URL that was accepted in the 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]

To-date though, even though the report processes without error, the passed in parameters don't make any difference/change in the report. So, I gave up on this approach and was somewhat successful with this approach (see my subsequent blog article).


Feedback

# re: Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal

Gravatar Did you ever find a solution to this problem I'm also attempting to pass a pararmeter to a TFS report but am in the same situation.

http://stackoverflow.com/questions/12723486/how-can-i-pass-a-parameter-in-a-url-to-a-tfs-report-2010

The link above suggesting an alterative approach is broken

10/4/2012 3:56 AM | Will Hearn

# re: Passing in report parameters to TFS 2010 OLAP Web Parts on the Team Portal

Gravatar I have corrected the link. It pointed back to my old blog site. I always work directly with the SSRS reports now and I like that fine. 10/4/2012 12:51 PM | Bob Hardister

Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

 

 

Copyright © Bob Hardister