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

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

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 manager along with sum of prices of his contracts.
  • It must represent all the information in tabular form.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

ManagerContract 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

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