How can I get the lable of a Parameter ? -- sql server reporting services

sql server reporting services : How can I get the lable of a Parameter ?

ALI-R
1/25/2005 2:33:05 PM

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.
Ali

Michelle NO[at]SPAM bwalk.com
1/25/2005 2:49:28 PM

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

ALI-R
1/25/2005 3:01:51 PM

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

[quoted text, click to view]

ALI-R
1/25/2005 4:54:51 PM

Yes,Bruse it is working,I misspelled Label as Lable:-) ,Funny then

Thanks for your help guys
[quoted text, click to view]

Bruce L-C [MVP]
1/25/2005 6:59:14 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn