如何使用Excel和报告服务器获取测试套件结果？ [英] How to use Excel and Reporting server to get test suite results?

问题描述

我想通过测试计划或测试套件将测试结果从TFS导出到Excel中。我知道我可以将Excel连接到TFS报告服务器，我已设法做到这一点。不幸的是，我不知道PFSOT表或TFS数据库的一些内部结构
来生成我需要的报告。有人可以分享一个示例或如何创建此类excel报告的步骤吗？ 

I would like to export test results from TFS into Excel by Test Plan or Test Suite. I understand I can connect Excel to the TFS reporting server and I have managed to do that. Unfortunately I don't know Pivot Tables that well or some of the internal structures of the TFS database to generate the report that I need. Can someone share an example or the steps on how to create this type of excel report? 

谢谢

推荐答案

您好Patrick，

Hi Patrick,

您可以按照以下步骤在Excel中为TFS测试结果创建数据透视表。

You could follow next steps to create a PivotTable for TFS Test Result in Excel.

1。打开Excel - >数据 - >来自其他来源 - >来自Analysis Services

1. Open Excel-->Data-->From other sources --> From Analysis Services

2。输入SQL Server实例名称，连接到SQL服务器后，选择"Test"。您可以看到分析数据库数据的修改时间，如果它不是最近的日期，请记住将所有TFS数据处理到Analysis数据库以使
确保Analysis Database中的数据是最新的。

2. Input the SQL server instance name, after connect to the SQL server, choose "Test". You could see the modified time of analysis database data, if it is not recent date, remember to process all your TFS data to Analysis Database to make sure the data in Analysis Database is up-to-date.

3。选择数据透视表，单击确定。

3. Select PivotTable Report, click ok.

4。您可以拖动所需的列和行，选择团队项目层次结构来过滤您的团队项目。

4. You could drag columns and Rows which you want, choose team project hierarchy to filter your team project.

最好的问候

这篇关于如何使用Excel和报告服务器获取测试套件结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！