为什么此Microsoft报告在试图导出时挂起？

Question

我在Microsoft中创建了一个非常简单的报告。报告数据从2个自定义SharePoint列表和UserInfo表中提取--这就是字段名长的原因。每当我运行SQL时，它都会非常快速地返回结果--看起来是正确的结果。但是，每当我回到报表视图并尝试将其打印为PDF或将其导出为PDF时，它将挂起。CPU固定在25% (我认为这是一个核心的全部使用)和内存使用只是增长和增长。我让它在我做其他事情的时候跑了大约两个小时，但是它没有完成。这真的是一种痛苦，虽然它不应该是。

我试过将两者都设置为内部连接，但没有运气。另外，如果我通过添加WHERE子句来限制结果，有时我可以让它打印结果。如果我使用的ID没有任何记录在第二表创新挑战最终进入表格，它将很快返回结果。但是，如果我将其限制在包含两个表中条目的单个结果上，导出/打印就永远不会完成。

下面是正在使用的SQL：

SELECT [Innovation Challenge].ID AS [Innovation Challenge_ID], 
[Innovation Challenge].[Create a name for your idea:], 
[Innovation Challenge].[Primary contact for your idea:], 
[Innovation Challenge].[Primary contact's group:], 
[Innovation Challenge].[Challenge question:], 
[Innovation Challenge].[Months to roll out:], 
[Innovation Challenge].[Idea Description ("What?")], 
[Innovation Challenge].[Reasons for Pursuit ("Why?")], 
[Innovation Challenge].[Notes:], 
[Innovation Challenge].[Coach you worked with:], 
[Innovation Challenge].[Do you want to be put in touch with other groups?], 
[Innovation Challenge].[If yes, please list the groups and explain:], 
[Innovation Challenge Final Entry Form].ID AS [Innovation Challenge Final Entry Form_ID],
[Innovation Challenge Final Entry Form].[What resources and capabilities do you need to implement your id], 
[Innovation Challenge Final Entry Form].[How much funding do you estimate you would need to develop and i], 
[Innovation Challenge Final Entry Form].[How confident are you in the likelihood of success?], 
[Innovation Challenge Final Entry Form].[Please provide rationale for your assessment of the likelihood o], 
[Innovation Challenge Final Entry Form].[Are there any significant risks (e#g#, operational, health, safe], 
[Innovation Challenge Final Entry Form].[If yes, please describe the potential risks:], 
[Innovation Challenge Final Entry Form].[What is the high-level impact?], 
[Innovation Challenge Final Entry Form].[Additional comments/notes, if needed:], 
[Innovation Challenge Final Entry Form].[Coach you worked with:], 
[Innovation Challenge Final Entry Form].[Is this submission complete?], 
[In

创新挑战最终进入表格[.RegistrationID，UserInfo.Name作为创新Challenge_Name，UserInfo.ID，创新Challenge.Attachments，创新挑战最终进入Form.Attachments作为Attachments_Innovation挑战最终进入形式，从(创新挑战左加入创新挑战最终进入形式)到创新挑战最终进入形式(创新挑战最终进入Form.RegistrationID)为您的想法联系：= UserInfo.ID；

任何帮助都是非常感谢的！我没有主意了！我们更希望得到即时的协助：

Answer 1

显然，Microsoft不能很好地处理要点。很多数据都包含了要点。我可以打印没有项目，但它挂在项目，包括项目要点。