The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads

need help

Last post 01-25-2008, 2:39 by Dinesh Asanka. 2 replies.
Sort Posts: Previous
  • need help

     07-25-2007, 5:34

    • Joined on 07-19-2007
    • Posts 4
    • Points 0
    • Top 50 Contributor
    hi , pls tel m how can i get the selected parameter multivalue to my designer textbox. i have tried like following 1) Parameters!BU.Label - error occured 2) Parameters!BU.value(0) - only first value 3) join(Parameters!BU.value,",") - return the uinquename like [Account dsc].[Business_Unit].&[1] but i need to get the only selected values. not the uniquename, not the first one. if i select three values in the param it should display. pls help me on this.
  • Re: need help

     07-27-2007, 3:43

    • Joined on 07-19-2007
    • Posts 4
    • Points 0
    • Top 50 Contributor
    answer: JOIN(Parameters!BU.Label,",")
  • Re: need help

     01-25-2008, 2:39

    • Joined on 03-26-2007
    • Colombo
    • Posts 21
    • Points 0
    • Top 10 Contributor
      Male

    Yes it is JOIN, Fro your information Opposite of the JOIN is SPLIT

    http://www.sql-server-performance.com/articles/reporting/report_parameters_p1.aspx


    Blog: http://dineshasanka.spaces.live.com
View as RSS news feed in XML

(Best viewed with a resolution of more than 1024 * 768)

Powered by Community Server, by Telligent Systems