how to pass MULTIVALUE parameter to db from telerik REPORT DESIGNER

[Anil]

I'm working on Telerik Report Designer (to be specific, not Visual studio)
I'm facing problem in passing multivalue parameter to proc
In proc, I have the parameter as: @parTest varchar(1000)

select data into #Temp1 from Products where data in (@parTest)

If I select a single value, the report runs good
But, if multiple values are selected, then I see the error in preview as :
'Procedure xyz has too many arguments specified'

how to pass MULTIVALUE parameter to db from telerik REPORT DESIGNER?
and how to use that parameter in proc ?

In some thread I saw:
"How do you pass multi value paramas to sql datasource?  I am trying to pass multi-value params but receive error  as below.  Would you please advise on how to do this or do you have an example/sample for multi-value params report somewhere that I can download? 
Failed to convert parameter value from a Object[] to a String.
------------- InnerException -------------
Object must implement IConvertible."

Reply:
"The DataSource Components don't work out of the box with a MultiValue Report Parameter since the current implementation is based on ADO.NET and does not allow you to pass a collection of values (set, array). Thus, the SqlDataSourceParameter accepts only single values corresponding to the SqlDataSourceParameter.DbType property. Although this is a known limitation of ADO.NET and not a problem of our product, we're currently working on possible solution for it and it would be part of the upcoming Q2 SP1."

fyi, I'm using Q2 - 2012

I also see:
"Currently the new DataSource Components don't work out of the box with a MultiValue Report Parameter. In order to use a multivalue Parameter you will have to create User Function that bulds a String from multivalue Parameter (Object[]) and use that string to set a SqlDataSource SelectCommand in the NeedDataSource event. Check out the attached sample project that illustrates how this scenario can be accomplished."

how can add the function in telerik report DESIGNER?

[Peter]

Hi Anil,

In Q2 2012 we have added support for the string function Join that you can utilize instead of the user function. We have attached sample report definition created with the Telerik Report Designer. In order to run it you will need the AdventureWorks database that came with your installation of Telerik Reporting. Additionally you will need GetByProductNames stored procedure:

USE [AdventureWorks]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[GetByProductNames]
@Names nvarchar(MAX)
AS
BEGIN
        SELECT p.ProductID, p.Name, p.Color FROM Production.Product AS p WHERE CHARINDEX( ',' + p.Name + ',', ',' + @Names + ',' ) > 0

END

Greetings,
Peter
the Telerik team

[Anil]

Thanks for ur quick response and straight solution.

The problem got resolved in my machine which is running Telerik Report Designer - Q2 2012 SP1 (version 6.1.12.820)

In my client machine running Telerik Report Designer - Q2 2012 (version 6.1.12.611), I'm unable to find the inbuilt function - 'Join' (while configuring DataSource Parameters)

Please provide solution for this too...

[Peter]

Hi Anil,

The build in Text functions including Join are introduced in the Q2 2012 SP1. Our suggestion is to upgrade your client Telerik Reporting installation.

Greetings,
Peter
the Telerik team