Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

report multi value

Posted on 2014-07-19
7
Medium Priority
?
289 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
  • 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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

876 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