Tuesday, February 14, 2012

Display dropdown parameter label on report

I have a dropdown parameter in my report (Sites) with the ID field as a
integer and the display field as a string. How can I display the selected
'display' field on the report? I can display the ID (int) ok with
= Parameters!SiteID.Value
But how can I get the actual selected dropdown text? Can't find this
anywhere!
cheers,
SimonYou can try:
= Parameters!SiteID.Label
"Anonymous Poster" wrote:
> I have a dropdown parameter in my report (Sites) with the ID field as a
> integer and the display field as a string. How can I display the selected
> 'display' field on the report? I can display the ID (int) ok with
> = Parameters!SiteID.Value
> But how can I get the actual selected dropdown text? Can't find this
> anywhere!
> cheers,
> Simon
>
>|||Excellent! Thanks
Simon
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:CE5FD740-6859-4830-AA02-76C8C97AED34@.microsoft.com...
> You can try:
> = Parameters!SiteID.Label
>
> "Anonymous Poster" wrote:
> > I have a dropdown parameter in my report (Sites) with the ID field as a
> > integer and the display field as a string. How can I display the
selected
> > 'display' field on the report? I can display the ID (int) ok with
> >
> > = Parameters!SiteID.Value
> >
> > But how can I get the actual selected dropdown text? Can't find this
> > anywhere!
> >
> > cheers,
> >
> > Simon
> >
> >
> >

No comments:

Post a Comment