Multiselect parameters

[harlowhair]

Hi,

I am slightly confused with multi select parameters - can these be automatically passed through to a SqlDataSource (referencing a stored procedure) as a comma delimited list, or do I have to manually create this string in the NeedDataSource event?

Thanks

[Steve]

Hello harlowhair,

Such scenario would work automatically since the latest Q2 SP1 2010 release, namely the following item: Fixed: SqlDataSource cannot map database parameter to multivalue report parameter.

Sincerely yours,
Steve
the Telerik team

[harlowhair]

Hi Steve,

The version I have is 4.1.10.921 which looks to be the latest however if I map the multiselect parameter to a stored procedure parameter it is passed through as null.  Is there a specific way this needs to be setup?

Thanks,
Rob

[Steve]

Hi Rob,

Yes, the version you're using is the latest. There must be some other problem unrelated to the new functionality if the parameter is returning null. You can use the FormatArray function from the ProductLineSales demo report and show the value of the report parameter in an expression to see its value. If necessary you can use the built-in IsNull function to check for such cases.

All the best,
Steve
the Telerik team

[harlowhair]

That worked - I created FormatArray in the code behind of my report and then used it in an expression to pass the parameter to the datasource

[Rakesh]

i am not able to get the result if i use multi select = true in telerik reporting services

[Rakesh]

Hi harlowhair
can you send a sample code how you did that