Friday, February 24, 2012

Get parameters name and value in report.

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,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
vetaldj wrote:
> 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,|||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"
<vkochubiy@.gmail.com> wrote in message
news:1153753663.900660.17760@.i42g2000cwa.googlegroups.com...
> 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,
>|||> 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"
> <vkochubiy@.gmail.com> wrote in message
> news:1153753663.900660.17760@.i42g2000cwa.googlegroups.com...
>> 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,
>

No comments:

Post a Comment