问题描述
我有两个使用 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 查询字符串中传递多值参数的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!