In-Table List with Filtering Grouping and Ordering in Word Processing Document
In this article, we will use GroupDocs.Assembly to generate In-TableList with Filtering, Grouping, and Ordering report in Word Processing Document format.
The code uses some of the objects defined in The Business Layer.
In-Table List with Filtering, Grouping, and Ordering in Microsoft Word Document
Creating a In-Table List with Filtering, Grouping, and Ordering
Practicing the following steps you can create In-Table List with Filtering, Grouping, and Ordering Template in MS Word 2013.
- Click the document where you want to add the table.
- Press “Insert” tab to insert the table.
- Insert a 2x2 table.
- Save the template.
Reporting Requirement
As a report developer, you are required to represent managers’ contract information with the following key requirements:
- Report must show each manager along with sum of prices of his contracts.
- It must represent all the information in tabular form.
- Report must be generated in the Word Processing Document.
Adding Syntax to be evaluated by GroupDocs.Assembly Engine
| Manager | Contract Price |
|---|---|
| «foreach [in getContracts() .where(c => c.getDate().getYear() + 1900 == 2015) .groupBy(c => c.getManager()) .orderBy(g => g.key.getName())]» «[key.getName()]» | «[sum(c => c.getPrice())]»«/foreach» |
Download In-Table List with Filtering, Grouping, and Ordering Template
Please download the sample In-Table List with Filtering, Grouping, and Ordering document we created in this article:
Generating The Report
ODT Template and Report in Apache OpenOffice
In order to check compatibility of ODT between Microsoft Office 2010 and Apache OpenOffice 4.1.2, we performed below tests:
- We opened the ODT template created through Microsoft Office 2010 in Apache OpenOffice 4.1.2. The template opened successfully in Apache OpenOffice without any issues or formatting losses.
- We opened the ODT report generated through GroupDocs.Assembly in Apache OpenOffice 4.1.2. The report opened successfully in Apache OpenOffice without any issues or formatting losses.