Hey all – John here. One of the things that we get asked frequently is how to report on SharePoint data. The answer is of course, “well, it’s easy, but it depends”.
In the spirit of clearing up the “it depends” part, I’m in the process of writing a series of articles that walks through the nuances of the various SharePoint complex data types. The first one shows some options for reporting on multi-value SharePoint columns, and includes tricks that pertain to more sources than just SharePoint.
You can find the post here. Enjoy!