index > Team Foundation Server - Reporting > How do i modify the filter on a report

How do i modify the filter on a report


A) How Can i remove/hide values in the severity filter

Currently the severity filter on the reports has following pick list values

1,1-Critcal, 2, 2-High, 3, 3-Medium, 4, 4-Low.

Can i remove the number values from the pick list: 1, 2, 3, 4 and Just display

1-Critcal,2-High,3-Medium,4-Low. ?

B) How Can i remove/hide Blank and Duplicate resources values in the "Assigned To" filter on the report.

How can i remove them from my "Assigned To" filter pick list values. and just display distinct and actual resources ?

MuraliMSDN

Hi Murali,

You can use the Business Intelligence Development Studio to modify your reports. Specifically what you'll do is modify the MDX query for the PriorityParam and AssignedToParam in the report. For both of these you can look at the "DefaultStateParam" dataset in the Work Items report as an example of specifically calling out parameters.

Download the report that you want to modify from the report server

  1. Navigate to http://<report server name>/reports
  2. Find the report you want
  3. Click the report name
  4. Click "Properties"
  5. Click "Edit" - this pops up a dialog to save or open - save it to disk
Mauli Shah - MSFT
reply 2

You can use google to search for other answers

 

More Articles

Errors when deploying to ReportServer
Report for finding Defect/Bug Frequency
Only one CUBE in Team Foundation Server
When trying to add a new VS2005 RDL file in my 2003 RS report ser...
replicate cool history tab in report
Where is the areapath in reoprts in TFS RTM?
TFS Project & Report Server ERrors
Turning a Work Item Query Into a Report
How do i edit or delete reports?
ReportProcessingException: The Language expression for the report...
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

date current state was set
Reporting Services Error
Datawarehouse, how can I do?
Label reports
TF53010 An unexpected exception occured …
Edit reports from Agile process template?
How to accss Symptom and StepsToReproduc…
Where are the Models?
Using Excel pivot charts, can I filter o…
An attempt has been made to use a data e…
Passing new parameters to Microsoft VB.N…
Cross Project Reports
Possible Bug in Warehouseadapter
Scenarios With No Tasks
Error exporting reports from Reporting S…

Hot Articles

Where are the Models?
Warehouse error question?
Improper Display in ReportViewer
Does Business Intelligence Development S…
Reports are present after upgrade to RTM…
How to create a report on Work Item Links?
Bug Rates Report - Getting very weird re…
code churn - ignore binary files?
Merged Changesets Report
SQL SP1 killed some reports
Problem with DATE dimension of RTM Team …
Why there is a fork icon in my report fo…
Report parameters problems
Projects are missing in reporting server
How the change in the data of Cube will …

Recommend Articles

How to connect to Database?
Error in Customising a existing report
Can't Create New Projects - Help Please?
Related WOrk Items With Code files?
What is the formal definition of Priorit…
Code Reviewer Report
Checkin Policy Override Report
Reports show no data - but it's there! …
"Hidden" reports in RTM ..
How to edit corewin_express.vsprops?
Using Excel pivot charts, can I filter o…
Passing new parameters to Microsoft VB.N…
How to accss Symptom and StepsToReproduc…
error uploading reports
Work Item Details Report