Solved

ssrs view parameter

Posted on 2009-04-13
2
710 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 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 question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
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…

739 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