Solved

ssrs view parameter

Posted on 2009-04-13
2
702 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

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.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

943 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now