In-Table Master-Detail in Email Document Leave feedback

Note

In this article, we will use GroupDocs.Assembly to generate an In-Table Master-Detail report in Email Document format.

Note

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

Practising the following steps you can create In-Table Master-Detail Template in MS Outlook 2013.

1. Create a new Email.
2. Click the email where you want to add the table.
3. Press “Insert” tab to insert the table.
4. Insert a 2x4 table.
5. Save the template.

As a report developer, you are required to represent the following key requirements:

• The report must be in .eml or .msg format.
• It must add email recipient, CSS and subject of the email.
• The report must show each customer along with his total orders prices.
• It must also show each individual product ordered by the customers.
• It must show sum of the order prices.
• It must represent all the information in tabular form.

Tip

For detailed technical information about syntax, expressions and report generation by the engine, please visit: Working with GroupDocs.Assembly Engine.

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

• in-table-master-detail.msg

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-master-detail.msg", "in-table-master-detail-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 master detail", "subject"),
])

Binary file (MSG, 55 KB)