I need to create a Stacked Column Chart with data from SharePoint 2010. What is the best way to get counts from the SP list grouped on one value? I have tried using separate datasets and the LookUpSet function, but I get errors trying to get the count. I also tried using LookUpSet().length but it is not recognized in the Series Properties expressions. Is there another way to get the count from the array brought back from the LookUpSet function?

Hi Skoch, To count the values in an array item returned by the Lookupset function, we can use a custom code. The following steps are for your reference: On the report Design surface, open the Report Properties window and click the Code tab.Copy the following function into the code box: Function CountItems(varArray as array) as integer Dim RetVal as integer RetVal = ubound(varArray) + 1 Return RetVal End Function Set the target expression like below: =code.CountItems(LookupSet(Fields!SalesTerritoryGroup.Value,Fields!SalesTerritoryGroup.Value,Fields!SalesTerritoryCountry.Value,"DataSet2")) Reference: Using Custom Code References in Expressions If you have any questions, please feel free to let me know. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.