How can I get the lable of a Parameter ?

I know that I can have access to the value of a paramter by using
Paramaters!Name.Value .I'm using a dropdown in my report which has lable and
values ,I'd like to get the lable not the value.
How can I do that?
Thanks for your time in advance.
AliHi Ali,
I find that =Paramaters!Name.Label will work MOST of the time.
I have several queried parameters and one that is not queried but has
values and lablels like: ="Q1-" & Year(Today)
The queried parameters work perfect with =Paramaters!Name.Label, but
the non queried parameter does not print if I use .Label However, it
will print if I use .Value
Take care,
Michelle|||My Problem is that I am using a non-queried parametre:-(
and I get an error if I use Parameters!Name.Value.What a bizzare,Isn't it?
Maybe Microsoft guys should add it to their wish list;-)
Ali
<Michelle@.bwalk.com> wrote in message
news:1106693367.969333.310150@.c13g2000cwb.googlegroups.com...
> Hi Ali,
> I find that =Paramaters!Name.Label will work MOST of the time.
> I have several queried parameters and one that is not queried but has
> values and lablels like: ="Q1-" & Year(Today)
> The queried parameters work perfect with =Paramaters!Name.Label, but
> the non queried parameter does not print if I use .Label However, it
> will print if I use .Value
>
> Take care,
> Michelle
>|||I'll double check this tomorrow at work but I don't think this is true.
.Label should always work. One thing to keep in mind is that the parameter
name is case sensitive. Parameters!somename.Value is not the same as
Parameters!SomeName.Value. Be sure that you have your parameter with the
appropriate case.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23wTTcHzAFHA.3988@.TK2MSFTNGP11.phx.gbl...
> My Problem is that I am using a non-queried parametre:-(
> and I get an error if I use Parameters!Name.Value.What a bizzare,Isn't it?
> Maybe Microsoft guys should add it to their wish list;-)
> Ali
> <Michelle@.bwalk.com> wrote in message
> news:1106693367.969333.310150@.c13g2000cwb.googlegroups.com...
>> Hi Ali,
>> I find that =Paramaters!Name.Label will work MOST of the time.
>> I have several queried parameters and one that is not queried but has
>> values and lablels like: ="Q1-" & Year(Today)
>> The queried parameters work perfect with =Paramaters!Name.Label, but
>> the non queried parameter does not print if I use .Label However, it
>> will print if I use .Value
>>
>> Take care,
>> Michelle
>|||Yes,Bruse it is working,I misspelled Label as Lable:-) ,Funny then
Thanks for your help guys
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eMb8inzAFHA.724@.TK2MSFTNGP10.phx.gbl...
> I'll double check this tomorrow at work but I don't think this is true.
> .Label should always work. One thing to keep in mind is that the parameter
> name is case sensitive. Parameters!somename.Value is not the same as
> Parameters!SomeName.Value. Be sure that you have your parameter with the
> appropriate case.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23wTTcHzAFHA.3988@.TK2MSFTNGP11.phx.gbl...
> > My Problem is that I am using a non-queried parametre:-(
> > and I get an error if I use Parameters!Name.Value.What a bizzare,Isn't
it?
> > Maybe Microsoft guys should add it to their wish list;-)
> >
> > Ali
> >
> > <Michelle@.bwalk.com> wrote in message
> > news:1106693367.969333.310150@.c13g2000cwb.googlegroups.com...
> >> Hi Ali,
> >>
> >> I find that =Paramaters!Name.Label will work MOST of the time.
> >>
> >> I have several queried parameters and one that is not queried but has
> >> values and lablels like: ="Q1-" & Year(Today)
> >>
> >> The queried parameters work perfect with =Paramaters!Name.Label, but
> >> the non queried parameter does not print if I use .Label However, it
> >> will print if I use .Value
> >>
> >>
> >> Take care,
> >> Michelle
> >>
> >
> >
>