Solved

report multi value

Posted on 2014-07-19
7
276 Views
Last Modified: 2014-07-27
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
Comment
Question by:minglelinch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40208030
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
 
LVL 1

Author Comment

by:minglelinch
ID: 40209670
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
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40209821
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 1

Accepted Solution

by:
minglelinch earned 0 total points
ID: 40210133
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
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40212372
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
 
LVL 1

Author Comment

by:minglelinch
ID: 40212395
Yes I just skip the parameters and just go back to the previous page. Thank you.
0
 
LVL 1

Author Closing Comment

by:minglelinch
ID: 40222294
Resolved
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the adminiā€¦

734 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