• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

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_Referred_Ranking"), Fields!Referred_Ranking.Value,Join(Parameters!Ranking.Value,"\#\"))

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!DayOfTheWeek)
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_clientName"), Fields!clientName.Value, Code.ShowParameterValues(Parameters!Client.Value))

Any help is appreciated.

Thank you, Lou
0
LouWolf
Asked:
LouWolf
  • 2
1 Solution
 
LouWolfAuthor Commented:
It was suggested that I try =Parameters!Ranking.Value.  This resulted in the Total of the matrix working when I drilled down to the detail report but, when I tried any other row \ column, it returned the Total data...each time.
0
 
LouWolfAuthor Commented:
Found this with the help of another Developer...

=iif(InScope("matrix1_Referred_Ranking"), Fields!Referred_Ranking.Value, Split(Join(Parameters!Ranking.Value,","),","))

Thanks, Tina
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now