Passing Multivalue Parameters

Hello Friends,

I have a report (Say Report 1)which is asking for a multivalue parameter Period. The user selects three period from the dropdown list available for the Parameter. Lets say that the user select 0407,0507,0607. Now is this report 1 there is a particular field which is linked to another sub report. So if the top level Report 1 supplies the revenue for 3 regions say for the periods selected then clicking on any of the regions would open a second detailed report, say Report 2 for the three periods as selected.

Till this everything is fine.

Now the problem is that in this detailed Report 2 there would be a particular text box as "Click here to naviagate back to parent report". So that when the user clicks on this cell he is taken back to the parent report, Report 1 which was originally generated for the 3 periods.

Can anyone please advise as to how the Multivalue Parameter which was passed from Report 1 to Report 2 can again be looped back to Report 1 from Report 2.

Thanx Friends,

Raktim

Hello Friends,

Please let me know if I made my post too much confusing.

I am keenly awaiting a solution for this.

Thanx,

Raktim

|||

Dear ,

Please help me also to pass parameter value thru report builder to get drill thru from report1 to report2.

I done the following ways

1. Type LocalHost/Reportserver

2. Take report builder and created two reports ie, report1, report2

3. Create drill through Sql server management studio for datasource in the model in report2

4. After that when I run the report , the error is coming ' ReportQuryParameter' missing

Please help me to solve this problem

regards

|||SSRS can pass Multi-value parameters from a report(Report 1 in your case) to its linked report (Report 2 in your case).
If Report1Period and Report2Period are Multi-value parameters (and 0407, 0507, 0607, and so on are possible values), all you need to do is to check the Multi-value property in the Report Parameters dialog box for both parameters (in Report1 and Report2).
From Report1, you can then set the Navigation (? Jump to Report: (press) Parameters…) property of the textbox property that you want your user navigate to Report2. The details you need to pay attention to is that you should pick <Expression… > from the Parameter Value drop down list for Report2Period.
In the SSRS Expression editor, if you double click the Report1Period (Parameters, <All>, Report1Period), the Editor will fill in a value like “=Parameters!Report1Period.Value(0)” which picks up only the first parameter in the multiple choice list.
You can erase the index (“(0)”) part of the expression to have liked report receive all the selected value. For example, you may want to set the value passed to Report2Period like “=Parameters!Report1Period.Value”.
As navigate back, the browser Back button will work. An alternative approach is to add additional Textboxes and set their Navigation ? Jump to Report property to the way you like.