Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    Unanswered: dropdownlist as a parameter

    Hi All,

    I have a dropdownlist which contains different ProdutIds.

    I have to use the values from the dropdownlist as a parameter to the report. How to use the dropdownlist to the Report?
    I'm using the Visual Studio .NET integrated Report Designer.
    In the data section of the integrated report desinger my code is something like this:
    SELECT
    <something>
    FROM
    Sales.SalesLog sl
    WHERE
    sl.transactionDate BETWEEN @startDate AND @endDate
    AND [dbo].[fn_FindStringInString](FullNameCountries,@productId) ='TRUE'

    I'd like to replace the @productId with the values selected by user from the dropdownlist which will be passed to a sql function which expects comma delimted string.

    Thanks for your help.

    N.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You can select more than one value in a dropdownlist..?
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2008
    Posts
    2

    Thanks

    Yes, user can select multiple values.
    Thanks.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    My point is that the ASP.NET DropDownList Control only allows the selection of one item...
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •