Groups | Blog | Home
all groups > sql server reporting services > july 2006 >

sql server reporting services : Get parameters name and value in report.


vetaldj
7/24/2006 8:07:43 AM
Hello,

Is there some way to get list of all parameters that used in report
FROM REPORT and show it in table? I need to have one page after my main
report that show report parameters summary.. I don't want to just
grug-n-drop them.. I have about 15 parameters...
I use Reporting Services 2000.

Thanks,
garrett.vlieger NO[at]SPAM gmail.com
7/24/2006 8:13:28 AM
You can use the RS web service methods to do this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3g0y.asp

[quoted text, click to view]
Amedeo Feroce
7/25/2006 2:39:00 PM
You can display the selected values from a multivalue parameter. The
following example uses the Join function to concatenate the selected values
of the parameter MySelection into a single string that can be set as an
expression for the value of a text box in a report item.

=
Join(Parameters!MySelection.Value)http://msdn2.microsoft.com/en-us/library/ms157328.aspx"vetaldj"
[quoted text, click to view]

Amedeo Feroce
7/25/2006 2:42:28 PM

[quoted text, click to view]


= Join(Parameters!MySelection.Value)


http://msdn2.microsoft.com/en-us/library/ms157328.aspx



"vetaldj"
[quoted text, click to view]

AddThis Social Bookmark Button