本文介绍了在 SSRS 查询字符串中传递多值参数的值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有两个使用 SSRS 2005 构建的报告.第一个报告设置为在单击特定字段时导航到第二个报告.我在文本框的跳转到 URL"属性中使用了类似于以下内容的表达式:

I have two reports built using SSRS 2005. The first report is set to navigate to the second when a specific field is clicked. I am using an expression similar to the following in the "Jump to URL" property of the textbox:

="javascript:void(window.open('http://server/reportserver?%2fFolder%2fMyReport&rs:Command=Render&Date=" & Fields!Date.Value & "&MachineId=" & Fields!Machine.Value & "'))"

第二份报告中有一个多值参数.调用此报告时,我需要在 URL 查询字符串中为此参数传递多个值.有没有办法为报表的查询字符串中的参数传递多个值?或者你能不能传递一个参数来使 Select All 值被选中?

There is a multi-value parameter on the second report. I need to pass multiple values for this parameter in the URL query string when calling this report. Is there a way to pass multiple values for a parameter in the query string of a report? Or can you pass a parameter that will cause the Select All value to be selected?

谢谢.

推荐答案

只需添加额外的查询字符串参数即可.

Just add additional query string parameters.

例如传递参数

Date:       2009-06-01
MachineID:  Machine1, Machine2, Machine3, Machine4

对于名为 server 的服务器上名为 Folder\MyReport 的报告,您可以使用 URL:

to a report named Folder\MyReport on a server named server, you would use the URL:

http://server/reportserver?%2fFolder%2fMyReport&rs:Command=Render&Date=2009-06-01&MachineId=Machine1&MachineId=Machine2&MachineId=Machine3&MachineId=Machine4

这篇关于在 SSRS 查询字符串中传递多值参数的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 12:22
查看更多