The function GetProjectNodeInfoFromReportFolder() is typically used to identify where the top data node is for an SSRS report.

• So the project GUID and/or the collection GUID.

The table that has this data in it is DimTeamProject found in the TFS warehouse.

Using this table given a ‘report path’ an appropriate Team Project can be identified.

DimTeamProject is what GetProjectNodeInfoFromReportFolder() uses to get the project node info for a path.

Here are a few notes around the use of GetProjectNodeInfoFromReportFolder().

Collecting the report path from the SSRS Built-in Field called ReportFolder.

A report path is required as a parameter to GetProjectNodeInfoFromReportFolder(). We need to get this from somewhere and set this path into a parameter (@vReportPath in this example) to use in the call.

Conveniently SSRS provides us with a way to do this using one of its Built-in-Fields; ReportFolder.

Note that in this example the report author has provided an alternative through the ExplicitProject parameter which is used to supply the report path if the reporting service Built-in Field called ReportFolder has no value; this will be the case when working on a report locally.

The call to GetProjectNodeInfoFromReportFolder() with report path parameter.

This call is made after the parameter has been been set; @vReportPath in this example.  ProjectGuid, ProjectNodeName and ParentNodeSK (which usefully is the SK of the collection) are returned. These returned values can then be used to update SSRS parameters for use in subsequent SQL queries for a report.

The DimTeamProject table.

Whenever a Team Project is created it is allocated a named folder in Reporting Service; the ReportPath.

Reporting Services makes this available to a running report as the global Built-in Field called ReportFolder.

The Report Folder.

The value for the SSRS global Built-in Field called ReportFolder is the path/location of the uploaded rdl files as below in Reporting Services.

Tweet.

TFS update 4 (and possibly previous updates)  run code coverage works one way and not the other.

I’ve got a couple of unit tests setup and I want TFS build code coverage .

I turned on code coverage as below and got no results with the TFS build.

The following way using the Add/Edit dialog from the ellipsis (…) as below does work.

So editing the build definition in this specific way. Process -> 1.Automated tests –> 1.Test source. Then using the ellipsis (…) pop up the Add/Edit dialog and then under Options dropdown change it from None to Enable Code Coverage.

Now I get code coverage results.

And now I can see code coverage in the reports.