Post reply

Dropdownlist as a param

  • October 7, 2008 at 5:02 am

    #382974

    In my report has 2 parameters, the 1st allows users to select which campanies they want to report on,the 2nd allows them to select which countries they're interested in.

    The code of my report is this:

    SELECT companies,Countries

    FROM[ReportsDb].dbo.MyTable

    WHERE [dbo].[fn_FindStringInString](CampanyCountries,UserSelectedCountries) ='TRUE'

    My function,fn_FindStringInString, expects 2 params the 1st is the countries each campany operates in and the 2nd the countries the user is interested in.Both are comma delimited strings.

    My problem is that I can't pass the countries chosen by the user from the dropdownlist to my function.

    How can I have the user selection from the dropdownlist into a comma delimited string and pass it to my funciton?

    I'm using the Visual Studio .NET integrated Report Designer

    Thanks for your help.

  • October 7, 2008 at 8:34 am

    #881714

    You can use stored procedure and then pass parameter to your stored procedure. From there on you can pass these parameter to your function. There might be other way around.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply