In-Table List in Email Document Leave feedback

Note
In this article, we will use GroupDocs.Assembly to generate a In-Table List report in Email Document format.

In-Table List in Email Document

Reporting Requirement

As a report developer, you are required to represent the information of the managers 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 customers’ name.
It must show the sum of orders prices against each customer.
It must sum up all the order prices for all the customers.
All the representation must be in tabular form.

Adding Syntax to be evaluated by GroupDocs.Assembly Engine

Customer

Order Price

<<foreach [in customers]>><<[CustomerName]>>

<<[Order.Sum(

c => c.Price)]>><</foreach>>

Total:

<<[Sum(

m => m.Order.Sum(

c => c.Price))]>>

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 Template

Please download the sample In-Table List document we created in this article:

in-table-list.msg

Generating The Report

Note
The example reads the shop data described in The Business Layer.

Python

import json
from datetime import datetime

from groupdocs.assembly import DataSourceInfo, DocumentAssembler

def parse_dates(item):
    # JSON has no dates: turn the order dates into datetime objects for the template
    for key in ("OrderDate", "ShippingDate"):
        if key in item:
            item[key] = datetime.strptime(item[key], "%Y-%m-%dT%H:%M:%S")
    return item

with open("customers.json", encoding="utf-8") as f:
    customers = json.load(f, object_hook=parse_dates)

assembler = DocumentAssembler()
assembler.assemble_document("in-table-list.msg", "in-table-list-report.msg", [
    DataSourceInfo(customers, "customers"),
    DataSourceInfo("Harbor Lane Provisions <orders@harborlane.example>", "sender"),
    DataSourceInfo(["Quayside Bistro <orders@quaysidebistro.example>", "jonas.weber@harborlane.example"], "recipients"),
    DataSourceInfo("amara.osei@harborlane.example", "cc"),
    DataSourceInfo("In table list", "subject"),
])

in-table-list.msg

The following sample file is used in this example: in-table-list.msg

customers.json

The following sample file is used in this example: customers.json

in-table-list-report.msg

Binary file (MSG, 40 KB)

Download full output

We value your opinion. Your feedback will help us improve our documentation.

In-Table List in Email Document Leave feedback