excel servies sql query用于为特定项目提取所有关联子任务的摘要任务

问题描述

是否有人知道如何使用"测试阶段"的任务名称来提取摘要任务。及其标记为摘要任务部分的任何项目的所有相关子任务？ 我可以在SSRS中获取一个项目，但是我需要能够
（由于我们使用的项目模板具有"测试阶段"作为摘要部分）查找每个包含此摘要部分的项目并将所有关联的子任务拉入excel数据透视表。 目的是能够在我们的投资组合中查看
并找到投资组合的所有测试阶段，以便进行一些调度分析。 我尝试了很多不同的查询，但似乎无法让它发挥作用。  ??

---

Cletus51

解决方案

Does anyone know of a way to pull a summary task with task name of "Test Phase" and all its associated subtasks for any project that has the summary task section labeled as such?  I can pull for one project in SSRS but I need to be able to (due to a project template we use that has "Test Phase" as a summary section) look for every project that has this summary section in it and pull all of the associated subtasks into an excel pivot table.  The intent is to be able to look across our portfolio and find all Testing Phases for the portfolio in order to do some scheduling analysis.  I have tried a number of different queries but cannot seem to get it to work.  ??

---

Cletus51

解决方案

这篇关于excel servies sql query用于为特定项目提取所有关联子任务的摘要任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！