Hi Bitmite,
Based on your scenario, I get that you have several paramters: StartDate(single value)/EndDate(Single value)/UserID(Muitl-value).
Here you want to pass the paramter value via the URL to jump to certain report from the original report. If I misunderstand you please feel free to let me know.
From the expression you gave,
I notice that the method is correct in your first expression. I make a test in local environment as well. I have two muitl-value parameters Month and Year, utilize the below expression and it works well, you could have a reference from below URL:
="http://challen1-msft/ReportServer?/DemoTest1/Muitl-parameterInURL&rs:Command=Render&Month="
& JOIN(Parameters!Month.Value, "&Month=")&"&Year="&Join(Parameters!Year.Value,
"&Year=")
Here, I would recommend you follow these steps to troubleshoot this issue:
1.
Have a check to your expression; it should be like top URL’s format. You could refer to
this as well
2.
Make sure you click the View Report button after selecting the mutil-value parameter, if not it will just pass the parameters’ default value
3.
Select the parameter, click view Report button, then click the link to jump to the report to see whether the link in the URL like this …….&rs:Command=Render&StartDate=9/6/2010&EndDate=10/7/2010&UserID=1121&UserID=1074&UserID=1106.
If not, the error must relevant to your expression.
4.
If step3 works fine, please have a check to your T-SQL for the dataset, as UserID is a muitl-value parameter, so the T-SQL should be like this:
Select * from dbo.table where UserID in (@UserID) and ……..
Please try top steps to troubleshoot the issue, and then give a feedback.
Thanks,
Challen Fu
