Link to home
Start Free TrialLog in
Avatar of minglelinch
minglelinch

asked on

report multi value

I have a question about multi value parameter paasing from drilldown report to parent report. I worked on this issue for a few days but unable to resolve it. I appreciate I can get help here.

The multi value parameter work fine at parent report. This parameter passed to drilldown report and the drilldown report works fine. Now I need to add a link to parent report, which means I need to pass that multi value parameter back to parent report.

let's say I have added a textbox on the drilldown report. By clicking the textbox, I want to return to the parent report with same data still displayed. Right now it seems that only one value of the multi values is passed, although it is multi value parameter. I tried using Join function but still not successful.

So how to pass a multi value paramter from a drilldown report to its parent report?

Thanks.
Avatar of Russell Fox
Russell Fox
Flag of United States of America image

The easiest way is to create a textbox on the main report that's set to be a hyperlink with the GoToReport action. The textbox can be in a table so that it goes to the drillthrough report for that record. When you select GoToReport as an action, you'll get another dialog box where you can specify both the drillthrough report and the parameters you want to pass to it. Here's a Microsoft how-to page.
Avatar of minglelinch
minglelinch

ASKER

Thank you for responding. I have done exactly what you mentioned above. My first level drillthrough works fine. I'm talking about from CHILD report back to PARENT, although it is same drillthrough technically.

To make it more clear, I have a main Report1 working, and drillthrough detail Report2 is also working. A multi value parameter is passed from Report1 to Report2. Now I created a textbox on the detail Report2, and  set to be a hyperlink with the GoToReport action, set Report1 as target report and passing the same multi value parameter back. The textbox is outside the data table so that it drills back to main Report1 for all records.

As a result of the above, it is not a success! If I select ONE value initially for the parameter on Report1, Report1 runs and I drill down to Report2 and I can go back from Report2 to Report1 by clicking the textbox. But if I select multiple values initally from prompt for the parameter for Report1, Report1 runs and I drill down to Report2, and then I come back to Report1 from Report2, it's not successfull, and no data is display!

Please help !
Got it, sorry. My guess is that the multi-valued parameter is being shortened into a single value for use in the Report2 query (by SSRS, not you). Try creating a textbox on Report2 on your development machine and just display that multivalue param - what shows up? Try it for both a single value and a multi-value. And to be clear, that parameter is set to accept multiple values in both reports, right?
ASKER CERTIFIED SOLUTION
Avatar of minglelinch
minglelinch

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Nice, so you just skip the parameters and just go back to the previous page. I'll have to remember that one! You should select your own post as the answer to help future users.
Yes I just skip the parameters and just go back to the previous page. Thank you.
Resolved