How To: Create Bugs By State RDLC report
- How to generate Bugs By State Graphical report .
Report Should Contain -
a) .Active Bugs Count
b) Resolved Bugs Count
c) Closed Bugs Count
d) Sum(A+B+C)
e) Fixed
f) Not Yet Assigned
Answers
What version of TFS are you running?
What type of report would you like to build (RDL for Reporting Services, Excel, etc...)?
The fields that you mention should all be in the Warehouse and Analysis DB (Cube). The first 4 fields sound like they are the Work Item State (System_State), the 5th field sounds like it is the Resolved Resolution Type (not sure the field), and the last field sounds like it is the Assigned To field (System_AssignedTo). The measure you are probably interested in is the count of work items (i.e. the Current Work Item Count in the TFS 2008 cube, or the row count in the Relational Warehouse).
How do you want to represent this data in a graph, do you multiple graphs, one for each field? For example (forgive my ASCII art - the X's are bars in a bar chart):
|
Work | X
Item | X X
Count | X X X
| X X X
------------------------------
Active Resolved Closed
Work Item State
Here is a good tutorial on the Cube (TFS 2008) - http://blogs.msdn.com/teams_wit_tools/archive/2007/04/30/understanding-the-tfs-cube.aspx- Marked As Answer byRuiz YiModeratorThursday, November 05, 2009 3:13 AM
All Replies
What version of TFS are you running?
What type of report would you like to build (RDL for Reporting Services, Excel, etc...)?
The fields that you mention should all be in the Warehouse and Analysis DB (Cube). The first 4 fields sound like they are the Work Item State (System_State), the 5th field sounds like it is the Resolved Resolution Type (not sure the field), and the last field sounds like it is the Assigned To field (System_AssignedTo). The measure you are probably interested in is the count of work items (i.e. the Current Work Item Count in the TFS 2008 cube, or the row count in the Relational Warehouse).
How do you want to represent this data in a graph, do you multiple graphs, one for each field? For example (forgive my ASCII art - the X's are bars in a bar chart):
|
Work | X
Item | X X
Count | X X X
| X X X
------------------------------
Active Resolved Closed
Work Item State
Here is a good tutorial on the Cube (TFS 2008) - http://blogs.msdn.com/teams_wit_tools/archive/2007/04/30/understanding-the-tfs-cube.aspx- Marked As Answer byRuiz YiModeratorThursday, November 05, 2009 3:13 AM
- Currently I am using TFS 2008. and I made a website to show reports from TFS. I am not using the reporting services.
The same way you have drawn , i need to display graph.
How to give filter conditions in the Graph itself.
What i have done is:
SELECT [System.State] FROM WorkItems WHERE [System.TeamProject] = '" @Project " ' AND [System.WorkItemType] = 'Bug' "
" AND [System.AreaPath] Under '" & ddlProjects.SelectedValue & CStr(IIf(ddlArea.SelectedValue = "All", "'", "\" & ddlArea.SelectedValue & "'")) & _
" AND [System.IterationPath] Under '" & ddlProjects.SelectedValue & CStr(IIf(ddlIteration.SelectedValue = "All", "'", "\" & ddlIteration.SelectedValue & "'")) & _
" AND [System.CreatedDate] >= '" & CDate(WDCStartDate.Text) & "' AND [System.CreatedDate] <= '" & CDate(WDCEndDate.Text) & "' " & _
" AND [System.State] = 'Active'"
After that resolved, then closed like wisethis way i will query it and add to collection and get the data and assign that collection as the datatable of report viewer.
Hi,
Nick has explained the database and cube that can be used for your report. If you have any question about how to use report viewer, it is better to VB(as I think you are using VB) forum. http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/Ruiz Yi
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi
