单击“返回"时报告查看器丢失参数 [英] Report viewer losing parameters when clicking 'back'

问题描述

场景:

在 Sharepoint 集成模式下安装的报告服务.

Reporting services installed in Sharepoint integrated mode.

我有 2 份报告:

Report A，一个简单的列表，带有过滤器的参数.具有指向另一个报告的行级链接(操作:转到报告)B，传入过滤器参数.

Report A, simple list taking a parameter for a filter. Has a rowlevel link (Action: Go to report) to another report B passing in a parameter for filter.

当通过Sharepoint(iow RSViewerPage.aspx)打开报表A时，提示输入参数.我提供它，然后单击应用".报告正确加载.在参数"窗格中，它显示报表 A 参数的名称和值.

When opening report A via Sharepoint (iow RSViewerPage.aspx), it prompts for the parameter. I provide it, and click 'Apply'. The report loads correctly. In the 'Parameters' pane, it shows the name and value for the parameter of report A.

现在我点击一个链接以使用提供的参数报告B.它会正确打开报告，并显示报告 B 参数的正确名称和值.

Now I click on a link to go to report B with the supplied parameter. It opens the report correctly, and shows the correct name and value for the parameter for report B.

到此为止一切正常.

现在我单击报告查看器(而不是浏览器)的返回"按钮，它使我正确返回报告 A 并应用了原始过滤器(如预期).问题是参数"窗格仍然显示上一个报告的 (B) 参数的名称和值.这导致您必须从头开始重新加载整个报告 (A).

Now I click the 'Back' button of the report viewer (not the browser), and it takes me back correctly to report A with the original filter appled (as expected). The problem is that the 'Parameters' pane still shows the previous report's (B) parameter's name and value. This causes you to have to reload the entire report (A) from scratch.

此外，当在错误的参数列表上单击应用"时，它会更新以显示正确的参数名称，但仍使用以前的值，再次有效地破坏了报告过滤.您必须再次重新加载报告 (A) 并重新开始.

Also, when clicking 'Apply' on the wrong parameter list, it updates to show the correct parameter names, but still uses the previous values, effective breaking the report filtering again. Again you have to reload the report (A) and start over.

我尝试在 Google 上搜索答案，但没有任何提示.

I have tried searching Google for an answer, but nothing pops up.

这已经在几个不同的服务器/工作站上进行了测试，这些服务器/工作站对 Sharepoint 和 SQL 的补丁/更新级别不同，所有这些都具有相同的效果.在不同的浏览器中也是一样的效果.

This has been tested on several different servers/workstations with different levels of patches/updates to Sharepoint and SQL all with the same effect. Also the same effect in different browsers.

有什么想法可以解决这个问题吗?

Any ideas how to fix this issue?

PS:人们会认为这是一种常见情况，但我不明白为什么没有解决这个问题，或者为什么没有其他人注意到这个问题.网络上有关子报表和钻取报表的所有信息，只需忽略返回"按钮即可.

PS: One would think this is a common scenario, yet it fails me why this has not been addressed or why no-one else has noticed the issue. All info on the web regarding sub- and drillthrough-reports, simply disregards the 'Back' button.

推荐答案

我找到了解决方案.

我用于 Sharepoint 的 RS 插件仍然是 RTM 版本.

My RS addin for Sharepoint was still the RTM version.

经过多次搜索，我找到了 Microsoft® SQL Server® 2008 R2SP1 功能包.

After much searching, I found the Microsoft® SQL Server® 2008 R2 SP1 Feature Pack.

您可以从那里下载 SQL2008 R2 SP1 的更新版本.

You can download the updated version for SQL2008 R2 SP1 from there.

该文件名为 rsSharepoint.msi.

这篇关于单击“返回"时报告查看器丢失参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！