In-Table List with Filtering Grouping and Ordering in Email Document
In this article, we will use GroupDocs.Assembly to generate a In-Table List with Filtering, Grouping, and Ordering report in Email Document format.
In-Table List with Filtering, Grouping, and Ordering in Email Document
This feature is supported by version 17.8.0 or greater
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 Outlook 2013.
- Create a new Email.
- 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 be in .eml or .msg format.
- It must add email recipient, css and subject of the email.
- Report must show each customer along with sum of prices of his orders.
- It must represent all the information in tabular form.
Adding Syntax to be evaluated by GroupDocs.Assembly Engine
Customer | Order Price |
<<foreach [in orders .Where(c => c.OrderDate.Year == 2015) .GroupBy(c => c.Customer) .OrderBy(g => g.Key.CustomerName)]>><<[Key.CustomerName]>> | <<[Sum(c => c.Price)]>><</foreach>> |
For detailed technical information about syntax,expressions and report generation by the engine, please visit: Working with GroupDocs.Assembly Engine
Download In-Table List with Filtering, Grouping, and Ordering Template
Please download the sample In-Table List with Filtering, Grouping, and Ordering document we used in this article:
Generating The Report
The code uses some of the objects defined in: The Business Layer