index > Team Foundation Server - Reporting > How do I set default value for a dimension variable to a value ot...

How do I set default value for a dimension variable to a value ot...


I am trying to create new report based on the OOB "Remaining Work" but have the report parameter "Work Item Type" default to a specific value other that "All (No Filter)"

I am working with the following out of the RDL

<ReportParameter Name="WorkItemTypeParam">

<DataType>String</DataType>

<DefaultValue>

<Values>

<Value>[Work Item].[System_WorkItemType].[All]</Value>

</Values>

</DefaultValue>

I cannot determine how to declare the "value" for the "Value" element.

I have tried a number of things like:

<Value>[Work Item].[System_WorkItemType].[Bug]</Value>

or <Value>[Work Item].[System_WorkItemType].[All].[Bug]</Value>

but when I render the report the parameter appears as a blank text box.

How do I define the default value for a report parameter to be one of the possible value of a dimension?

Thanks in advance

Tom

Tomb1

Probably the easiest way to change the default value for the parameter is to:

Browse to the Report you would like to modify
  Browse to http://<Report Server>/Reports
  Click the directory with your project name
  Click on the report you would like to modify (Remaining Work)

Change the default property value
  Select the Properties Tab (at the top of the report)
  Select the Parameters page (on the left of the page)
    See the list of parameters for this report
  In the "Default Value" for the WorkItemTypeParam enter:
    [Work Item].[System_WorkItemType].&[Bug]

 

Nick Ericson - MSFT
reply 2

You can use google to search for other answers

 

More Articles

Creating an OLTP datasource for writing reports
How to Updating report from stored procedure
Reports are present after upgrade to RTM, but they don't work
Datawarehouse, how can I do?
Passing new parameters to Microsoft VB.Net Report(.rdlc)
Unplanned work report incorrect
replicate cool history tab in report
Failed to load adapter
Related WOrk Items With Code files?
How do i edit or delete reports?
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

how to install report designer?
Reuse query definition in reports ?
replicate cool history tab in report
How to create a new Report in Team Found…
Unable to generate a model from the OLAP…
Where are the Models?
Reports not accessible through project p…
reports not showing up on home page
URL for the 50 standard TFS reports
Setting default parameter for project in…
Checkin Policy Override Report
How to accss Symptom and StepsToReproduc…
Reports for all current active projects
Setting for URL in Reporting services
Reporting on all Projects

Hot Articles

Standard team project reports have empty…
Is there a way to select the executed te…
How to Remove the row which doesn't have…
Another TFS Warehouse problem...
TFSWarehouse shows data but reports come…
Only one CUBE in Team Foundation Server
"TF53010: An unexpected condition h…
Error in Reporting
How to create a new Report in Team Found…
Error when trying to display a report
Datawarehouse, how can I do?
Having trouble deploying to the report s…
Printing Reports from within Team Explorer
After upgrading to latest VSTS reports a…
The synchronization issue of the reporting

Recommend Articles

How to prevent users from viewing other …
SQL SP1 killed some reports
Reports using customized Workitems
Error Generating model for Olap Data Sou…
msmdsrv using 50% cpu for minutes
What is the formal definition of Priorit…
Errors when deploying to ReportServer
Another warehouse not updating :( - now …
TfsWarehouse Database not updated with a…
Edit reports from Agile process template?
Reports against Version Control
How to create a report on Work Item Links?
Warehouse error question?
The synchronization issue of the reporting
Unplanned work report incorrect