Generating a report from multiple lists
You can use JungleDocs to generate reports containing data from multiple SharePoint lists. In this tutorial, you will learn how to do this.
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.
Note: Microsoft Office 2010 has a 64 character limit for the Tag field, so try to use compact view names for this. Office 2013 does not have this limitation.
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
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: