Solved

report multi value

Posted on 2014-07-19
7
279 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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 …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 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