TNWiki Article Spotlight – Build custom reports for SharePoint on-premises

Welcome to another Tuesday TNWiki Article Spotlight.

SharePoint administrators like metrics. They want to know when users are engaging with their system and at what rate. For an on-premises solution, this means reporting on when pages are viewed or modified. To build this report, data can be pulled from the Usage and Reporting service application, the content database, and the pages library in SharePoint Server 2013.

To see how this can be accomplished, Dan Christian has created an award-winning article entitled How to build a custom report for SharePoint Server lists, libraries or sites for the TechNet Wiki. In the post, Dan shows us where the data we need is located, how to build the structure of the report using data connections and datasets, and finally how to create a table with expressions to get the required information.

The great thing about this article is that Dan supplements all three text sections with an in-depth embedded YouTube video. Each one readers through all the steps visually which makes for an excellent addition to the article. To see these videos check out his YouTube channel.

If you ever wanted to know more about how to build custom reports for SharePoint on-premises, read his article.

by Ken Cenerelli (Twitter,  Blog,  MSDN Profile,  MVP Profile)