子报告总是失败 [英] Subreports always fail

问题描述

我正在使用SQL Server Report Builder 2016.我没有连接到报表服务器。我的所有报告都在我的本地计算机上。

I am using SQL Server Report Builder 2016. I am NOT connected to a report server. All of my reports are on my local machine.

当我创建报告并进行预览时，一切都很顺利。返回数据并按预期进行描述。

When I create a report and preview it, all looks well. Data is returned and depicted as expected.

当我尝试在文本框上实现操作时，我选择"转到报告"。我在框中输入报告的名称，然后单击"确定"。然后，当我预览报告时，所有看起来都很好，直到我点击应该引导我到第二个报告的框。在
每个案例中，我收到一条消息，说"在本地报告处理期间发生错误"和"对象引用未设置为对象的实例"。

When I try to implement an Action on a text box, I choose "Go To Report". I enter the name of the report in the box and hit OK. Then, when I preview the report all looks fine until I click on the box that should lead me to the second report. In every case I get a message saying "An error occurred during local report processing" and "Object reference not set to an instance of an object".

认为我的设计一定做错了，我回到文本框，去了属性，这一次点击"浏览"找到链接的报告。导航窗口默认为"最近的站点和服务器"。并且
不允许我导航到我的第二个报告，即使它与当前报告位于同一目录中。没有导航按钮工作，我无法更改"查找"按钮夹。没有办法浏览我的报告！我唯一的选择是"取消"，
关闭对话框。

Thinking I must have done something wrong in my design, I went back to the text box, went to properties, and this time hit "Browse" to locate the linked report. The navigation window defaults to "Recent Sites and Servers" and does not allow me to navigate to my second report, even though it is in the same directory as the current report. None of the navigation buttons work, I can't change the "Look in" folder. There is no way to browse to my report! My only option is "Cancel", which closes the dialog box.

如上所述，我试图直接输入第二份报告的名称，包括有和没有文件扩展名无济于事。似乎没有任何内容导致第二次报告。不，没有所需的参数或依赖项。我甚至用
简单的"Hello world"尝试了它。尝试进行故障排除时报告。

As stated, I have tried to enter the name of the second report directly, including with and without the file extension to no avail. Nothing seems to lead to the second report. And no, there are no parameters needed or dependencies. I even tried it with a simple "Hello world" report while trying to troubleshoot.

我还访问了报表生成器选项，以确保"默认情况下将报表部件发布到此文件夹"。是正确的。它是。主要报告和辅助报告都在指定的文件夹中。 "按
默认使用此报表服务器或SharePoint站点"是空白，因为我没有使用报表服务器或SharePoint站点，直到我的测试报告正常工作。

I also went to Report Builder Options to ensure that "Publish report parts to this folder by default" is correct. And it is. The primary and secondary reports are both in the indicated folder. "Use this report server or SharePoint site by default" is blank, as I am not using a report server or SharePoint site until my test reports are working as they should.

我应该使用更好的开发工具吗？

Is there a better development tool that I should be using?

推荐答案

你好 tim_claremont

根据你的描述，你得到的详细问题是什么？

According to your description , what the detailed issue you got ?

如何在导航中获取报告？这两个报告是否在同一个项目中？

How you could not get your report in the navigate ? Does the two report are in the same project?

您是否有足够的权限访问子报告？

Do you have enough permission to access the sub report ?

您可以检查在以下方面。

You could check in the following aspects .

• 对于默认的"最近的站点和服务器"在导航中，您可以尝试在底部的"名称"输入标签
  中输入完整的报表服务器地址。过了一会儿，  它将跳转到相应的报表服务器，而不是最近的报表服务器。
• 如果可能，您可以尝试连接到报表生成器中的对应报表服务器。然后检查是否可以连接到子报告。

• For the default "Recent Sites and Servers" in the navigate , you could try to input the full report server address in the bottom "Name" input label . after a while,  it would jump to the correspond report server , not the recent one.
• If possible you could try to connect to the correspond report server in the report builder .And then check if you could connect to the sub report .

如果您不想使用报告构建器2016，可以尝试在

ssdt 。

If you do not want use the report builder 2016 , you could try to edit the report in the ssdt.

您可以向我们提供有关您的问题的更多详细信息（屏幕截图，gif图像更好）以供进一步研究。

You could offer more detailed information about your issue (screen shot , gif image are better) to us for more further research.

希望得到你的回复。

最好的问候，

Eric Liu

这篇关于子报告总是失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！