How do i modify the filter on a report  
Author Message
Murali Medisetti





PostPosted: Team Foundation Server - Reporting & Warehouse, How do i modify the filter on a report Top

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



Visual Studio Team System24  
 
 
Mauli Shah - MSFT





PostPosted: Team Foundation Server - Reporting & Warehouse, How do i modify the filter on a report Top

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

Open Visual Studio Editor:
Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Business Intelligence Development Studio
** This also may be under Microsoft Visual Studio 2005 if you have that installed.

Create a new project:
File -> New -> Project
On "New Project" dialog
Select "Business Intelligence Projects" under Project types.
Select "Report Server Project" under Templates.
Enter Name, Locations, Solution Name, ...
OK

Create the data sources:
In the Solution Explorer pane:
Right click on "Shared Data Sources" -> "Add New Data Source"
On the "Shared Data Source" dialog
On the General Tab:
Name: TfsOlapReportDS
Type: "Microsoft SQL Server Analysis Services"
Next to Connection String text region click "Edit..."
On the "Connection Prpperties" dialog:
Server name: <Report Server Name>
Click the Down arrow under "Connect to a database" - this can take a little bit to populate, wait until the dropdown appears
Select "TFSWarehouse"
Click "Test Connection"
This pops up a dialog indicating the connection is good.
OK
OK

Repeat these steps to create the TfsReportDS (Microsoft SQL Server) data source. Select the TFSWarehouse for the database as well (they have the same name).

Edit the deployment properties for the project
In the Solution Explorer pane:
Right click the project (above Shared Data Sources) and select Properties
On the <Project Name> Property Pages dialog:
In the left pane select Configuration Properties -> General
In the right pane, under Deployment set:
OverwriteDataSources: False
TargetDataSourceFolder: /
TargetReportFolder: /<TFS Project Name>/
** This is not your Report Project - this is the name of the TFS project this report is for.
TargetServerURL:
http://<Report Server Name>/ReportServer
OK

Add the report to the solution

  1. In the solution explorer pane, right click on "Reports"
  2. Add->add existing item - navigate to where you saved the report

Modify the dataset

  1. Now click on the "Data" tab
  2. In the drop down list select "AssignedToParam" - now you'll see the MDX for the parameter set

let me know how it goes.