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:
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.