Login   Register 
Receive news via our XML/RSS feed
Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles
  • Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
    Creating an SSL Certificate to ensure your confidential reports remain confidential


  •  
    Boost Data Ltd.
     
     
    SQL Reporting Services - Answers to your questions
     
    Author Thread: Multi Value Parameter
    Kathyc

    Multi Value Parameter
    Posted: Monday, March 23, 2009 11:03 PM (GST)
    <P>I have a paramater in my report called "Users"<BR>This paramater is of type "String" and is multi-value.</P> <P> </P> <P>I need to display in my report in a textbox the users<BR>that were selected. For Example: Joe Smith Bob Jones</P> <P> </P> <P>I have no idea how to do this</P> <P> </P> <P>Can someone please advise me.</P>
     

    Comments:  

    Author Thread:
    William Vaughn
    Multi Value Parameter
    Posted: Monday, March 23, 2009 11:05 PM (GST)
    Cathy, if you create a TextBox report item, you should be able to populate it with the value of the Parameter in an expression. Go to the Expressions dialog and look for the "Parameters" item. This should lead you to the right parameter. hth
    William Vaughn
    Multi Value Parameter
    Posted: Monday, March 23, 2009 11:06 PM (GST)
    Sorry... "Kathy"
    jmarkman
    Multi Value Parameter
    Posted: Monday, March 23, 2009 11:25 PM (GST)

    Try:    JOIN(Parameters!Users.Label, ", ")

     

    This will return a comma delimited list of the user names in the multi-value parameter.   

     
     
     
     
     
    Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About