Imagine I have a report (on my Reporting Services server) that show a list of work items (e.g. enhancement requests) filtered by some condition (e.g. with state "Assigned to Analyst"), and the main report's field, Title, is marked as EnableDrilltrough = True in the appropriate report model. So when I view the report I can click one a work item's title to see... an almost blank page with the only heading "Work Item" - I suppose the heading the the appopriate table's name in my TFS Warehouse database, and I need to see a work item's details (a sort of details report) - how can I do this How can I create such a report (similar to a work item's form I see in my Visual Studio environment) Should I link such a (details) report with Work Item table How Thanks in advance.
Work Item Details Report
Hot Topic
- TF2006: Could not connection to the Team Foundation Server.
- Scripting tf.exe using wscript.shell
- Chinese characters mxied up in Word format maunal test script
- Team Project Creation Faild- not able to connect to the SQL Reporting Services at http://192.168.0.1:8080/
- TFS SErver Beta3 single server installation failed
- Decent amount of memory to run Virtual PC
- How to Export Team Project
- I do unit test on native C++ using .Net FrameWork, but I cann't access non-intercase class in the unit test project.
- ReportServer and missing System.XML
- Team Build Error - TF42046 - Unable to Execute Team Build
VS Team System
- How can I import work items from one project to another?
- How can I transfer the old version files into another database?
- Is there a maximum number of virtual users allowed for load testing?
- Permissions bug?
- Problem installing VS 2005 Team Suite
- Team Build, Web Projects and References???
- Client for Team Foundation version control
- How to change directory in a tf script?
- Two different ID's seems to see the same set of workspaces
- Error when i create a Team Project
Work Item Details Report
bitbonk
Hi Stanislav,
The following topic details how to do this. Are you using a relational or OLAP model
http://msdn2.microsoft.com/en-us/library/ms159752.aspx
Thanks,
tom
kathyw
Thanks for the link but I saw it before and it did not help anyhow... I am trying to create drillthrough reports for my TFS Warehouse database so I suppose I use a relational model. I know "How to Map a Predefined Report in a Report Model", say, specify single instance and multiple instance reports for Work Items table but I have either of the two problems:
1. Report Builder allows to specify "Allow users to drill to this report from other reports" in a report properties, but it does now allow to create a details report in the form of
FieldName1: FieldValue1
FieldName1: FieldValue1
... ... ... ... ... ... ...
FieldName1: FieldValue1
Report Builder allows only to create "Table (columnar)", "Matrix (cross-tab)" or "Chart" reports, and all of them are not details report I need for a record in Work Items table.
2. Report Designer aka SQL Server Business Intelligence Development Studio aka Visual Studio 2005 allows to create advanced reports, with almost any layout, including reports that are details reports in the form displayed above but the reports created cannot be open in Report Builder (why it is all about RDL files...) thus cannot be marked as "Allow users to drill to this report from other reports", and I do not know how to set this property in another way, and without it such report cannot e set as a drillthrough report for an entity (table) in SQL Server Management Studio...
Any idea how to solve any of the two problems Thanks in advance.
gli268
Hi Stanislav,
Sorry for the long delay on this. Although Report Builder and Report Designer both build RDL files, they are not interchangeable. Report Builder reports can be modified in Designer, but not the other way around.
To accomplish what you are after, you should start with a report builder "list" report, and then modify it using report designer. You can do this by downloading the RDL file from the server, and adding it to an RD project. Because it started life as an RB report, it has the "drillthrough context" that enables it to know which "Entities" are in play when the report is navigated to from a report builder report.
Next, you need to tie the RD report to be a drillthrough report for an Entity (in this case, Work Item). You do this after deploying the report and model. In SQL Mgmt Studio, connect to reporting services, and select the model, and double click on your model under the "Models" folder. In the "Drill-through reports" tab on the model dialog, specify the location of your deployed RD drillthrough report.
Hope that helps,
tom