More info: here's what I have in the Dataset Parameter Value

=Code.ReturnXML(Parameters!C.Value,"C","CUSTOMER","CUSTOMER_NUMBER")

but when I go look at the ExecutionLog the Parameter Passed is...

C=10165&C=10008&C=10162&C=10009&C=10007&C=10137&C=10179&C=10171&C=10002&C=10003&C=10001&C=10004&C=10154&C=10196&C=10005&C=10122&C=10153&C=10157&C=10006&C=10152&C=10125&C=10172&C=10214&C=10010&C=10159&C=10176&C=10055&C=10063&C=10126&C=10011&C=10012&C=10013&C=10020

I guess I would have expected it to...

Yes I did that - can you read my last post - it runs now but doesn't return anything - should I have the [1] on there?

ok - adding the code.Return... enable it to run - however with no results.

Is this right for in my sp

C=my parameter name

Customer=label

Customer_Number=int value

INNER JOIN

@C.nodes('/C/Customer') as m(item) on (CS.CUSTOMER_NUMBER)...

Ok just changed the code property to :

Function ReturnXML(ByVal MultiValueList As Object, ByVal Root As String, ByVal Node As String, ByVal Element As String) As String

...

Ok just changed the code property to :

Function ReturnXML(ByVal MultiValueList As Object, ByVal Root As String, ByVal Node As String, ByVal Element As String) As String

...

I get an error - Next control variable does not match For Loop control variable 'sParamItem' should I be customizing any of the function in the code property?

I have tried nvarchar(8000) and varchar(4000) and varchar(max) all fail. The parameter passed that is stored in the ExecutionLog table is 223 characters. That isn't the 'Select...

The report works with 215 character parameter string but adding one more making it 223 it fails. This has to be something associated with the length of the parameter.

Any...

I have the same issue - the job will fail - but if I run in manually it runs.

Here's the deal - we had a problem a few weeks ago and one of the guys deleted the log file. So, we created a new Database same name...

Ok, looks like we don't have analysis services turned on (built) for that server. Is that how it works? It's just turned on?