blogger counters

Monday, April 19, 2010

Report Parameters in Dashboards via URL Parameters

I had a recent question about how to customize the Burndown and Burnrate report to show both tasks and bugs. By default this report only shows tasks. Unfortunately, it’s not very easy to customize the report to change the default from task to both task and bug.

However, you can create a URL to the report that will set the default to both work item types. Here’s how. Let’s say you have a URL to your report that looks something like this:


The following rewrite of this URL will display the same report, but with both Task and Bug selected by default:

http://server/ReportServer/Pages/ReportViewer.aspx?%2fTfsReports%2fDefaultCollection%2fAgile%2fProject+Management%2fBurndown+and+Burn+Rate&WorkItemTypeParam=[Work Item].[System_WorkItemType].%26[Bug]&WorkItemTypeParam=[Work Item].[System_WorkItemType].%26[Task]

The parameter that controls the work items is called WorkItemTypeParam, and it expects values that are from the cube (see my post on Customizing Report Parameters for how to get the actual value to use). When you want to supply more than one value, as here, you need to repeat the parameter assignment once for each parameter value. I’ve highlighted the two instances of the parameter assignment above.

Note: You need to have the %26 in front of each work item type in order for this to work. Reporting Services is very picky—the value you send to a parameter has to match the parameter values exactly. The Burndown and Burnrate report has & characters (%26 when encoded) in front of [Bug], etc., which means that these are key values.


At 4/19/10, 1:30 PM, Anonymous Anonymous said...

What language is this. I'm 88 and it totaly escapes me.
I have been in half of Europe and most of the Pacific (with the Marines)
Stone age S Scale modeler, and architectural modeler in the past.
(12 countries & 82 FORTUNE Magazine ads)
John Armstrong

Good work on the truck

At 4/5/11, 5:41 AM, Anonymous Anonymous said...

Hi John,
This is a wonderful article!! I was able to get some of the parameters passed in the URL. But I am unable to get the Iteration Start Date passed in the URL. Any help will be appreciated.


At 4/1/13, 11:15 PM, Blogger hemcoined said...

what a great article!
Loading System

At 11/11/13, 10:41 PM, Anonymous Blue Okapi said...


Est-ce que ce genre de vidéo motion design peut vous intéresser?

Nos tarifs sont compris entre 1500€ h.t. et 2500€ h.t. pour une durée de 60s-90s, selon la complexité, et tout est inclus (story-board, effet spéciaux, voix-off, musique...)

Nous avons aussi des offres de vidéo classique de qualité à tarif low-cost.

Avez-vous un projet sur lequel vous pouvez nous mettre en compétition?
Je peux aussi vous envoyer notre grille tarifaire si vous avez des besoins dans le futur.

Bien à vous

Julie Arbanas
01 43 49 47 47


Post a Comment

<< Home