将 Project Server 和 SharePoint 中的数据合并到单个报告中
我需要将 Project Server 报告数据库中的数据与SharePoint 工作区中的自定义列表中的数据结合起来。结果需要显示在单个报告中。这应该怎么做呢？我想到的选项：
使用自定义列表数据扩展报告数据库（如果可能）。使用 Reporting Services 显示输出。
查询报告数据库和 SharePoint 工作区并合并内存中的结果。编写自定义代码来显示输出。
还有其他想法吗？我有开发此功能的技能，但如果它能解决问题，我非常愿意购买该产品。
I need to combine data from the Project Server reporting database with data from custom lists in SharePoint workspaces. The results need to be displayed within a single report. How should this be done? Options I've thought of:
Extend the reporting database with the custom list data (if this is possible). Use Reporting Services to display the output.
Query the reporting database and the SharePoint workspaces and combine results in memory. Write custom code to display the output.
Any other ideas? I have the skills to develop this but am very open to purchasing a product if it solves the problem.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我也遇到过这样的问题。我的方法：
创建自定义报告数据库。
从 SQL Server 运行常规作业来查询共享点（通过 WS）并将结果存储在数据库中。
我使用ListItemsChangesSinceToken is Lists.asmx来提高效率。我还使用 sitedataquery 工具集。我在其中编写了一个非常简单的接口，以便能够远程调用 sitedataquery，返回 dataTable。
使用 Reporting Services/任何工具来提取和报告数据。
我选择临时数据库的原因是为了
希望这有帮助。
I've had this sort of problem as well. My apporach:
Create a Custom reporting Db.
Run regular jobs from the SQL Server to query sharepoint (via WS) and store the results in the db.
i use the ListItemsChangesSinceToken is Lists.asmx to improve effeciency. Also I utilise the sitedataquery tool set. I wrote a really simple interface into it for the ability to call a sitedataquery remotely, returning a dataTable.
Use Reporting Services / any tool to extract and report on the data.
The reason I opted for a staging Db was for
Hope this helps.
我还发现了工具 SharePoint Data Miner ，它似乎具有相同的功能作为DJ的回答。
I also found the tool SharePoint Data Miner which appears to do the same as DJ's answer.