# In-Table List with Filtering Grouping and Ordering in HTML Document # In-Table List with Filtering, Grouping, and Ordering in HTML Document {{< alert style="info" >}}In this article, we will use GroupDocs.Assembly to generate In-TableList with Filtering, Grouping, and Ordering report in HTML Document format.{{< /alert >}}{{< alert style="info" >}}The code uses some of the objects defined in [The Business Layer](https://docs.groupdocs.com/assembly/java/the-business-layer/).{{< /alert >}} ## In-Table List with Filtering, Grouping, and Ordering in HTML Document ### Reporting Requirement As a report developer, you are required to represent managers' contract information with the following key requirements: * Report must show each manager along with sum of prices of his contracts. * It must represent all the information in tabular form. * Report must be generated in the HTML Document. ### Adding Syntax to be evaluated by GroupDocs.Assembly Engine
| <<foreach \[in getContracts() .where(c => c.getDate().getYear() + 1900 == 2015) .groupBy(c => c.getManager()) .orderBy(g => g.key.getName())\]>> <</foreach>> | |
| Manager | Contract Price |
| <<[key.getName()]>> | <<[sum(c => c.getPrice())]>> |