Generating a report from multiple lists
You can use JungleDocs to generate reports from multiple views or lists at once. However, you will need to configure the JungleDocs template accordingly. 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 selected list. So in order to retrieve data from other lists, you will have to associate the template with these lists/views. This can be done using the GetView() function.
- To use the function, create a table, select one row, then select Rich Text Content Control in the ribbon:
- Click Properties.
- Enter GetView("List Name";"View Name") in the Tag and Title fields:
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
- Now you need to add more content controls that will represent columns from the list you specified. For example, if you need to create a report for a list of companies, and you want the table to contain company names, addresses
andemails of the companies, you'll need to add corresponding content controls inside the GetView() content control:
- To include data from yet another SharePoint list, create another table and specify the list in GetView(). 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: