LouWolf
asked on
Pass multi value parameter from matrix to detail report
Hi Experts,
I have a matrix report that has a multi-value parameter. I am passing this parameter to a detail report but, only 1 value or "ALL" is passed. If I choose only a few of the parameters to pass then the detail report parameter is blank and the report doesn't run. My code to pass the parm is below:
=iif(InScope("matrix1_Refe rred_Ranki ng"), Fields!Referred_Ranking.Va lue,Join(P arameters! Ranking.Va lue,"\#\") )
I have tried using the custom code found at the following url: http://msdn.microsoft.com/en-us/library/ms155798.aspx.
Public Function ShowParameterValues(ByVal parameter as Parameter) as String
Dim s as String
If parameter.IsMultiValue then
s = "Multivalue: "
For i as integer = 0 to parameter.Count-1
s = s + CStr(parameter.Value(i)) + " "
Next
Else
s = "Single value: " + CStr(parameter.Value)
End If
Return s
End Function
=Code.ShowParameterValues( Parameters !DayOfTheW eek)
I put this code (below) under Textbox properties, Navigation, Jump to report, Parameters and am still receiving only blanks when I 'jump to' the detail report.
=iif(InScope("matrix1_clie ntName"), Fields!clientName.Value, Code.ShowParameterValues(P arameters! Client.Val ue))
Any help is appreciated.
Thank you, Lou
I have a matrix report that has a multi-value parameter. I am passing this parameter to a detail report but, only 1 value or "ALL" is passed. If I choose only a few of the parameters to pass then the detail report parameter is blank and the report doesn't run. My code to pass the parm is below:
=iif(InScope("matrix1_Refe
I have tried using the custom code found at the following url: http://msdn.microsoft.com/en-us/library/ms155798.aspx.
Public Function ShowParameterValues(ByVal parameter as Parameter) as String
Dim s as String
If parameter.IsMultiValue then
s = "Multivalue: "
For i as integer = 0 to parameter.Count-1
s = s + CStr(parameter.Value(i)) + " "
Next
Else
s = "Single value: " + CStr(parameter.Value)
End If
Return s
End Function
=Code.ShowParameterValues(
I put this code (below) under Textbox properties, Navigation, Jump to report, Parameters and am still receiving only blanks when I 'jump to' the detail report.
=iif(InScope("matrix1_clie
Any help is appreciated.
Thank you, Lou
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER