Solved

ssrs view parameter

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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 …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video discusses moving either the default database or any database to a new volume.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

707 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

14 Experts available now in Live!

Get 1:1 Help Now