Support for Multi-Valued parameter in Custom Data Extension

I have a stored procedure which returns me a list of values. I am letting the user select 1, some or all of those values. When I try to pass this multi-valued parameter to my Custom Data Processing Extension, I get this:

An error occurred during local report processing.

Cannot add multi value parameter 'Value' for dataset 'ReportData' because it is not supported by the data extension.

My question is. How do I make my data extension support multi value parameters and if that is not an easy task, how do you go about sending in the comma delimited string coming out of the multi value parameter. Is it an interface I have to implement? Is there something that has to be set in the config file?

[759 byte] By [DavidMaynard] at [2007-12-22]

«« MSSQL 2000 Installation problem.
»» .NET remoting rookie. Need HELP! Unhandled Exception

# 1

Yes, your custom data extension must implement additional interfaces. Particularly, you have to implement the IDataMultiValueParameter interface (http://msdn2.microsoft.com/zh-tw/library/microsoft.reportingservices.dataprocessing.idatamultivalueparameter.aspx)

Based on that, the RS processing engine will then set the IDataMultiValueParameter.Values property to an object[] that contains all the selected parameter values. It is then up to your custom data extension to process the multiple values in the ExecuteReader() call.

-- Robert

RobertBrucknerMSFT at 2007-8-30 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

Thank you Robert, that is exactly what I was looking for.

DavidMaynard at 2007-8-30 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech