Work Item Details Report

Imagine I have a report (on myReporting 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 asEnableDrilltrough = 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 myTFS 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 myVisual Studio environment)? Should I link such a (details) report with Work Item table? How? Thanks in advance.

[867 byte] By [StanislavOgryzkov] at [2007-12-21]

«« LINQ Preview May 2006 on 64bit XP Professional
»» Type Ahead in Dropdown

# 1

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

TomPatton at 2007-9-10 >

top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...

# 2

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.

StanislavOgryzkov at 2007-9-10 >

# 3

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

TomPatton at 2007-9-10 >

Visual Studio Team System

Team Foundation Server - Reporting & Warehouse

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech