Passing multivalued parameter from parent report to child report in Reporting service

I have report which accepts multi Value paramter in the Parent Report, this report has a drill down feature. but when i try passing the multi value parameter to the child report only the 1st value in the list is passed.

Parent Report accepts multiple users and based on which it shows the total % of issues submitted by thoses selected users in the multi value list. on drill down i need to send the user list again from the parent so that the child report shows each issue in detail. but when i use Parameters!Users.value i get only the 1st selected value.

could any one pls help me achive this requirement of mine.

thanks

Chandresh Soni

Are the data coming from Analysis Services or are they based on a relational data source?

For the relational case I recommend reading the following forum posting: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=163803&SiteID=1

-- Robert

|||

Yes the data in the first report was coming through relational database. and i had given a drill down feature in the first report which takes to the second report which shows the details information off the parameter(multivalued) selected from the first. it worked for me.

I appreciate yr help - Robert

Passing Multi-Value parameters to a Data Driven Subscription

Hi,

I've been asked to set up a data driven subscription for a number of reports which use multi value parameters. For example, show me all transactions against the following departments: IT, Building Services, Accounts.

As an interactive report it's simple, the user just selects the relevant departments, but as a data driven subscription I can't seem to find the correct format to pass the selections through.

Has anyone tried this before?

Thanks,

Dan

please search on "Multi-Value parameters to a Data Driven Subscription" in this forum.

Passing multi value parameter to the Drill through report

Hi

I have two reports say Report A and Report B.

Both reports using same parameters.

I am Navigating from Report A to Report B using Jump to Report option.

Now when I pass multiple parameter to the Report B it only displays first parameter results.

In report B I have parameter multi value select to true.

I would like to know if its possible or not to pass multi value parameter in drill through report?

I would appreciate if someone can help me here.

Regards

Amit

Yes you can pass multi value parameters to a drill through report.

It works similar to multi value parameters for subreports, which is discussed in detail in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=163803&SiteID=1

-- Robert

|||

Thanks Rob.

That helped.

passing multi value parameter to stored procedure

I wrote a Stored Procedure spMultiValue which takes Multi Value String Parameter "Month". The stored procedure uses a function which returns a table. when I Execute the stored procedure from SQL Server 2005 with input "January,February,March" everything works fine.

In the dataset , I set command type as Text and typed the following statement.

EXEC spMultiValue " & Parameters!Month.Value &"

its not returning anything.

can anyone tell me how to pass multivalue parameter to stored procedure.

Thanks for your help.

Change the command type to Stored Procedure and type

SPMultiValue

Now click OK and hit the refresh button. Now go back to Edit the dataset and go to parameters tab and map it with the correct parameter.

For multi value parameter within stored procedure you need to decode the multi values to be able to use in the query.

|||

Thanks for u'r reply. I have GroupDataBy parameter. Based on that value I need to call different stored procedure.

I have to use commond type As text. Is there any way to pass Multi value parameter for the following statement

"Exec spMultiValue '" & Parameters!Month.Value & "'"

|||Change Parameters!Month.Value to Parameters!Month.IsMultiValue

Passing multi value parameter between reports

I've seen some theads on this but cant seem to get this right. Report A has 5 parameters 2 of them are multi value-- when I click on part of Report A I want to jump to report B and pass all parameter values from report A. The single value ones work but multi value only passes on value and not all values selected-- what am I missing here? Do I need to pass the values in the multi value parameters in an array?

thanks

k

Duuhhhh

someone definelty has a case of the mondays going-- changed =Parameters!code.Value(0) to =Parameters!code.Value

and all is well.

k

Passing Multi Value Delimited string to a parameter

Hi Everyone,
I am using, or want to use a parameter as a filter in a sql statement, the
user will pick from a list that will then send a delimited list of numbers
e.g. "a1,a2,a3,a4" as the parameter that will be referenced in the sql
statement with a " field IN (@.parameter) " type thing.
Im sure this should work and its probably just the phrasing or something
that ive got wrong, can anyone help?
Steve DMulti-select parameters are a feature of RS 2005. This will not work in RS
2000. You can do dynamic sql to do this (note that you do open up to
injection attacks). Switch to generic query designer (to the right of the
...). Put in something like this.
="select somefield from sometable where anotherfield in (" &
Parameters.ParamName.Value & ")"
Note that RS will not detect your field list, so first have a regular query
to populate the field list.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve Dearman" <steve.dearman@.grant.co.uk> wrote in message
news:OFZt89YWGHA.1564@.TK2MSFTNGP03.phx.gbl...
> Hi Everyone,
> I am using, or want to use a parameter as a filter in a sql statement, the
> user will pick from a list that will then send a delimited list of numbers
> e.g. "a1,a2,a3,a4" as the parameter that will be referenced in the sql
> statement with a " field IN (@.parameter) " type thing.
> Im sure this should work and its probably just the phrasing or something
> that ive got wrong, can anyone help?
> Steve D
>

Passing an multi array to sql from java over jdbc

Hi Guys,

I am fairly new to PL and I am trying to solve this problem.

I need to pass a two dimensional array(A variable Name and Variable value) to a stored procedure in PL/SQL. I dont want to pass this data as a big string..I was hoping to passing it as an array because it would be easier to handle the data.

Basically I would be calling this procedure from a java program over JDBC.

My question is how do I create this...

Since I would be filling this from Java, it would be a parameter within the procedure something like

CREATE OR REPLACE PROCEDURE Test_Response ( pisa_response Varchar[][] )

Of course Varchar[][] is not supported by PL but just showed this to give more understanding of the problem

Any help on this would be really appreciated..

Thanks in advance..

Regards,
FreakieCheck the thread in the Java section of this "dbForums" for details.|||Hi Thanks 4 the reply...

From what I gathered.. I might need to send it as a string...but I do not want to do that...

I basically want to send it as an array of strings... I am not sure whether using ORacle.sql.array feature might help???

Regards,
Freakie|||Again, check the thread in the Java section of this forums. Its got
complete code to perform what your looking for, so long as your
running Oracle 9i.

pass value to sub report

hi ,
I need to pass multi selectes value to my sub report. to do so , i have done like the following,
=Parameters!ReportServer.Value & "/ResourceCost&rcarameters=false&rc:zoom=100&rc:Toolbar=true&BU=" & JOIN(parameter!BU.label)

Bu is the multi select value and need to pass ot to the sub report dataset mdx query.

sub report mdx:
SET [FilteredBUSet] AS descendants({strtoset(@.BU)},[Account—BillingCodeDsc].[Billing Code Description],leaves) .
How can i achieve this task. cant find a way. pls help me.
The problem is like this guys. once we click the link in the main report , it should go to the another report. multi selected values in the main report should pass to another report. need to access those coming params to access in the mdx query in the navigated report. can use like following in the navigation tab -> jump to url and can use the following.

=Parameters!ReportServer.Value & "/ResourceCost&rcarameters=false&rc:zoom=100&rc:Toolbar=true&Year="
& Fields!Year.Value & "&Quarter="
& Fields!Quarter.Value & "&InScope="
& InScope("Months") & "&Month=" & Fields!Month.Value & "&Sample=" & (Fields!Business_Unit.Value)

this business value is the multivalue. it may contain lot params like that. this also have some problem. and also if we have lot of params to pass to other report then cant use query string coz of the limitation of the query string. so can some one say how to pass param values to another report in good manner?
|||

I used this to pass multivalue parameters to a subreport

example

=Split(Join(Parameters!GDC1.Value,", "),", ")

=Join(Parameters! <ParameterName> .Value,", ")

An expression that concatenates all the values in the array of a multivalued parameter of type String into one string.

=Split("Value1, Value2, Value3",",")

Takes a string and creates an array of objects that can be used to pass to a subreport or drillthrough report expecting a multivalue parameter.

http://msdn2.microsoft.com/en-us/library/aa337292.aspx

hope this helps

pass value to sub report

hi ,
I need to pass multi selectes value to my sub report. to do so , i have done like the following,
=Parameters!ReportServer.Value & "/ResourceCost&rcarameters=false&rc:zoom=100&rc:Toolbar=true&BU=" & JOIN(parameter!BU.label)

Bu is the multi select value and need to pass ot to the sub report dataset mdx query.

sub report mdx:
SET [FilteredBUSet] AS descendants({strtoset(@.BU)},[Account—BillingCodeDsc].[Billing Code Description],leaves) .
How can i achieve this task. cant find a way. pls help me.
The problem is like this guys. once we click the link in the main report , it should go to the another report. multi selected values in the main report should pass to another report. need to access those coming params to access in the mdx query in the navigated report. can use like following in the navigation tab -> jump to url and can use the following.

=Parameters!ReportServer.Value & "/ResourceCost&rcarameters=false&rc:zoom=100&rc:Toolbar=true&Year="
& Fields!Year.Value & "&Quarter="
& Fields!Quarter.Value & "&InScope="
& InScope("Months") & "&Month=" & Fields!Month.Value & "&Sample=" & (Fields!Business_Unit.Value)

this business value is the multivalue. it may contain lot params like that. this also have some problem. and also if we have lot of params to pass to other report then cant use query string coz of the limitation of the query string. so can some one say how to pass param values to another report in good manner?
|||

I used this to pass multivalue parameters to a subreport

example

=Split(Join(Parameters!GDC1.Value,", "),", ")

=Join(Parameters! <ParameterName> .Value,", ")

An expression that concatenates all the values in the array of a multivalued parameter of type String into one string.

=Split("Value1, Value2, Value3",",")

Takes a string and creates an array of objects that can be used to pass to a subreport or drillthrough report expecting a multivalue parameter.

http://msdn2.microsoft.com/en-us/library/aa337292.aspx

hope this helps