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


SharePoint 2013 LogoWelcome 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 (TwitterBlogMSDN ProfileMVP Profile)

Comments (3)

  1. Hello everybody.

    Would be interesting to see (could not find how the author deals with it) if anything changed with the direct content database querying for production databases - as for now it seems to be not a recommended way to access the data.

    https://blogs.msdn.microsoft.com/brian_farnhill/2013/12/04/directly-querying-sharepoint-databases/

    It might be an appropriate solution for POC (proof of concept) but could not find mentions of this as well.

  2. I love the depth in Dan's articles, and this one is another detailed article! It's a very useful scenario.

    1. Hello Ed ) nice to see you here )

Skip to main content