Solved

Pass multi value parameter from matrix to detail report

Posted on 2008-11-03
2
528 Views
Last Modified: 2012-06-21
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
Comment
Question by:LouWolf
  • 2
2 Comments
 

Author Comment

by:LouWolf
ID: 22869341
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
 

Accepted Solution

by:
LouWolf earned 0 total points
ID: 22871784
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help creating a stored procedure 4 56
How to check data in sql table 11 45
sql help 5 52
Parsing the XML data to SQL Server 4 59
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now