I am returning my data from the lookupset function into an array, separated by a comma. I need to split this array into different rows. Can this be done? Thanks

Hi, You can use Spilt function. =Split(<<lookupset expression>>,",") Kindly replace <<lookupset expression>> with your Lookupset expresion. -Chintak

Hi DSedlak, Spliting an array into rows is not supported in current version(SQL Server Reporting Services(SSRS) 2008 R2). I would suggest you using SubReport instead in this case. Or, please submit a wish at https://connect.microsoft.com/sqlserver. If the service requests frequently, we may include it in the next release. Thanks, Jin ChenJin Chen - MSFT