InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:16:59 GMT20http://www.sqlservercentral.com/Forums/Topic1073311-150-1.aspxOkay, thanks anyway, Daniel.Fri, 04 Mar 2011 08:25:39 GMTSimon E Doubthttp://www.sqlservercentral.com/Forums/Topic1073311-150-1.aspxIf I understand the error you are passing an object rather than an integer array. Unless you can deal with that in your code by taking the object apart and converting it to an integer array, I don't have any additional suggestions. Good luck.Fri, 04 Mar 2011 08:01:58 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1073311-150-1.aspxThanks very much for the suggestion, Daniel.Unfortunately, it fails with the following error:[code="plain"]The GroupExpression expression for the tablix ‘Tablix2’ contains an error:Unable to cast object of type 'System.Object[]' to type 'System.Int32[]'.(rsRuntimeErrorInExpression)[/code]Fri, 04 Mar 2011 07:52:13 GMTSimon E Doubthttp://www.sqlservercentral.com/Forums/Topic1073311-150-1.aspxI think all you want is [code="other"]Parameters!paramBoxSizes.Value[/code]If you were looking for a single value you would use something like:[code="other"]Parameters!paramBoxSizes.Value(0)[/code]Fri, 04 Mar 2011 07:45:20 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1073311-150-1.aspxHello All,I have a report with the following elements:- A mutli-valued parameter (@paramBoxSizes), whose data type is Integer- A VB function implemented in the 'Code' section called GetBoxSizeGroup that wants an integer array as one of its input parameters- A tablix with some groupsIn one of the Group Expressions in my tablix, I would like enter an expression that passes my mutli-valued parameter values as an array of integers to my VB function.Unfortunately, I've only been able to find the SPLIT function, which will pass a string array, not an integer array.[code="plain"]=Code.GetBoxSizeGroup(Split(Parameters!paramBoxSizes.Value,","))[/code]I was hoping to avoid having to convert the array inside my VB function from a string array to an integer array. Does anyone have any suggestions?Many thanks,-SimonFri, 04 Mar 2011 07:25:19 GMTSimon E Doubt