TFS Report and .rdl files

Initial set up of the Team Project defines default reports. The plug-in responsible for the reports within TFS is call Microsoft.ProjectCreationWizard.Reporting. Report XML file is located in the Reports folder of the Team Project and is called ReportsTasks.xml.

In order to run reports we need to define reporting website which will have a link to it on the project portal Home Page under Reports label. This link can be set with XML element called task:
<task id="Site" plugin="Microsoft.ProjectCreationWizard.Reporting" completionMessage="Project Reporting site created.">
    <dependencies/>
    <taskXml>
        <ReportingServices>
            <site />
            <folders>
                <folder path="Public"/>
            </folders>
        </ReportingServices>
    </taskXml>
</task>

We also can create our own folder on the reporting website using folder element. We need to set relative path name of the new folder.
<folder path=""/>

All of our reports have .rdl file extensions. In order to add these reports we need to copy .rdl files into folder under the Reports folder in the process template and then with the help of the report element describe properties of this report.
<report name="" filename="" folder="" cacheExpiration ="30">

In addition, we can specify values for a report parameters.
<parameters> <parameter name="" value=""/> </parameters>

We are required to map data source name in each report to TFS data source
<datasources> <reference name="The name of the data source in the report." dsname="The name of the Team Foundation Server data source. Typically this value is either TfsReportDS or TfsOlapReportDS."/> </datasources>

Here is a complete example of such a mapping
<report name="Work Items" filename="Reports\Work Items.rdl" folder="" cacheExpiration ="30">
<parameters>
        <parameter name="Project" value="$$PROJECTNAME$$"/> </parameters>
<datasources>
    <reference name="/TfsOlapReportDS" dsname="TfsOlapReportDS"/>
    <reference name="/TfsReportDS" dsname="TfsReportDS"/> </datasources>
</report>

Featured pages

SharePoint Integration

Windows SharePoint Services is an integral part of Team Foundation Server. As a result, there is v…

Creating Team Project

Team Foundation Server allows creation of the portal project via TFS Portal Creation Wizard. This …

SQL Server Agent Jobs

Team Foundation Server installs several SQL Server Agent Jobs that allow it to perform certain tas…

tf Command

tf Command line utility provide many useful operations that we can perform with Team Foundation Se…

Shelving and Unshelving

Shelving is very powerful feature of the Source Control in VSTS that allows storing pending change…

MS Project Fields Mapping

TFS works with MS Project via mapping file with specific fields mapped from one application to ano…

Using MS Project with Team Foundation Server

MS Projects allows accessing Team Foundation Server and working with the TFS Work Items. This is a…

Managing Documents in TFS

Team Foundation Server provides us with the capability to manage various documents, also called ar…