Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ssrs view parameter

Posted on 2009-04-13
2
Medium Priority
?
712 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
[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
2 Comments
 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 80 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

688 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