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

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.
0
minglelinch
Asked:
minglelinch
  • 4
  • 3
1 Solution
 
Russell FoxDatabase DeveloperCommented:
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.
0
 
minglelinchAuthor Commented:
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 !
0
 
Russell FoxDatabase DeveloperCommented:
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?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
minglelinchAuthor Commented:
Yes. It is set a multi-value.
I have just resolved it by add the expression as "javascript:history.go(-1)" . It works great.
Thank you.
0
 
Russell FoxDatabase DeveloperCommented:
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.
0
 
minglelinchAuthor Commented:
Yes I just skip the parameters and just go back to the previous page. Thank you.
0
 
minglelinchAuthor Commented:
Resolved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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