SQL parameter "WHERE ... IN @param"

[Fridli Jacober]

Hi,
I'm trying to pass a list of guids to a report but it does not work (there are no results).

SELECT     [...]
FROM         [...]
WHERE     (Object_ID = @ObjectID) AND cast(Node_OrganisationID as varchar(40)) IN (@OrganisationList

the sql statement directly on the sql server works:

SELECT [...]
FROM     [...]
WHERE   (Object_ID = '4c10e1f9-288c-441d-827d-cb2ca8bf85ac') AND cast(Node_OrganisationID as varchar(40)) IN ('83E37722-61A0-4780-8F4C-00D39FB6AA92','BB85E950-3BC4-4A2A-B413-791730D58A5D',[...])

'83E37722-61A0-4780-8F4C-00D39FB6AA92','BB85E950-3BC4-4A2A-B413-791730D58A5D' Does not seem to be the correct syntax to pass the guids to the parameter in telerik. Can you help me with the correct syntax?

Thanks

[Peter]

Hello Roland Meier,

Generally this is impossible with the ADO.NET functionality (see discussion here). The good news is that such possibility is already implemented by Telerik Reporting and will be available in the upcoming SP1.

Greetings,
Peter
the Telerik team