Generating a report from multiple lists

Applies to JungleDocs for SharePoint 2010-2019.
For a similar tutorial for JungleDocs for Office 365, click here.

You can use JungleDocs to generate reports containing data from multiple SharePoint lists. In this tutorial, you will learn how to do this.


Using the GetView function

If you run JungleDocs from a list, it will work in the context of that list. So in order to retrieve data from other lists, you will have to associate the template with these lists. This can be done using the GetView function.

1. To use the function, create a table, select one row, then select Rich Text Content Control in the ribbon.

2. Click Properties.

3. In the Tag and Title fields, enter GetView("List Name";"View Name") and specify the list and view you want to retrieve metadata from.

Notes
  • Microsoft Office 2010 has a 64 character limit for the Tag field. Office 2013 and later versions do not have this limit.
  • To learn more about content controls, see Adding content controls to document.

4. On the row with the GetView function active, select cells one by one and add content controls inside, configured to retrieve metadata from the specific columns of the list that the GetView function refers to. For example, if you want to create a report for a list of companies, and you want the table to contain company names, addresses and emails, you'll need to add corresponding content controls inside the GetView content control.

5. To include data from yet another SharePoint list, create another table and specify the list in the GetView function. This way, you can combine data from as many lists or views as you like in the same report.


Other ways to merge data from multiple lists

The tutorial above represents the simplest way to create a JungleDocs document referring to more than one SharePoint list. You might also be interested in:

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us