Solved

ssrs view parameter

Posted on 2009-04-13
2
709 Views
Last Modified: 2012-05-06
I have utilized the information in the related topic to create a multi-valued parameter to be passed into a subreport.  The main report has a parameter named SpendDateCalendarYrQtr, as does the subreport.  I also set up a report variable on the main report named SpendDateCalendarYrQtr which has a value (using an expression) of Parameters!SpendDateCalendarYrQtr.Value(0) + "," + Parameters!SpendDateCalendarYrQtr.Value(1).  When I preview the report in Visual Studio though, it seems that the report is passing in more values than just the 2 I selected, so I need a way to see what values are getting passed into the subreport.  How can I view the values being passed in by parameter?  (using a text box on the subreport doesn't seem to work)
0
Comment
Question by:Kaporch
2 Comments
 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 20 total points
ID: 24129365
Kaporch,

Populating a parameter with the code Parameters!SpendDateCalendarYrQtr.Value(0) + "," + Parameters!SpendDateCalendarYrQtr.Value(1) will result in one text field with the two values in the form of valueone, valuetwo.

In order to use this in your subreport you either need to create two parameters and pass each value individually (easy solution) or split the string using a split function in the sub.

0
 

Accepted Solution

by:
Kaporch earned 0 total points
ID: 24129591
Thanks, that's not what I was asking.  I wanted to be able to view the values being passed into the reports at run time.  How can I debug and view the values being passed?
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
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…

679 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