Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nejibg
Starting Member
3 Posts |
 Posted - 2008-10-07 : 07:59:57
|
| Hi all,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,CountriesFROM [ReportsDb].dbo.MyTableWHERE [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 DesignerThanks for your help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 08:02:21
|
| make the parameter type as multivalue. then parameters.value will give you comma seperated list when user selects multivalue. |
 |
|
|
|
|
|
DropDownList as a param