In-Table List in HTML Document

Note
In this article, we will use GroupDocs.Assembly to generate In-Table List report in HTML Document format.
Note
The example reads the shop data described in The Business Layer.

In-Table List in HTML Document

Reporting Requirement

As a report developer, you are required to represent the information of the customers and the total order prices with the following key requirements:

  • 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.
  • Report must be generated in the PowerPoint Document.

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:

Generating The Report

import json

from groupdocs.assembly import DataSourceInfo, DocumentAssembler

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

assembler = DocumentAssembler()
assembler.assemble_document("in-table-list.html", "in-table-list-report.html", DataSourceInfo(customers, "customers"))

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

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

<html>
<body>
<table>
<tr>
<th>
Customer
</th>
<th>
Order Price
</th>
[TRUNCATED]

Download full output

Close
Loading

Analyzing your prompt, please hold on...

An error occurred while retrieving the results. Please refresh the page and try again.