In-Table List with Filtering Grouping and Ordering in Email Document

Note
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

Note
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.

  1. Create a new Email.
  2. Press “Insert” tab to insert the table.
  3. Insert a 2x2 table.
  4. 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>>

Tip
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

Note
The code uses some of the objects defined in: The Business Layer