January 28, 2011 at 1:50 am
Hi All,
I have a navigation property from Report1 to Report2 , both the report has two parameters say Month,AccountName, with AccountName is a multivalued parameter.
In the navigation tab of Report1 I have give the expression as:
="void window.open('"+Globals!ReportServerUrl+"?"+Globals!ReportFolder+"/"+"Report2&rs:Command=Render&rc:Parameters=false&Month="+Parameters!Month.Value+"&AccountName="+Code.GetValue(join(Parameters!AccountName.Value(),","))+"')"
But after running Report1 , when I click on the section to navigate Report2, I'm getting the message in the internet Explorer as "The parameter AccountName is missing value"
I'm getting this error only when I select more than one value for the prameterAccountName, but if I run the report for only one value, it is working as expected.
Can some one let me know what can be the problem here.
Thanks.
Thanks & Regards,
MC
January 28, 2011 at 4:33 am
Hi MC,
You cannot pass multi value parameter like that as the sub report parameter does not accept a coma separated value. But i am not sure why Microsoft has not considered this.
Instead you have to pass like ParameterName=Value1&ParameterName=Value2 ........
To convert the multi value parameter values to this format you can use a custom function (written in custom code window).
Public Function MyString(PName as String, TempStr as String) as String
Dim str as String
str = Replace(TempStr,",", "&" & PName & "=")
Return str
End Function
and in the navigation link you can use ParameterName=Code.MyString("ParameterName",JOIN(Parameters!ParameterName.Value(),","))
Regards
Dileep
Regards
Dileep
January 28, 2011 at 5:22 am
Hi Dileep,
Thanks a lot.. it worked.. 🙂
Thanks & Regards,
MC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply