1. GroupDocs Documentation
    2. /
    3. GroupDocs.Assembly Product Family
    4. /
    5. GroupDocs.Assembly for Java
    6. /
    7. Developer Guide
    8. /
    9. Advanced Usage
    10. /
    11. Working with Table Reports - Filtered Ordered Grouped
    12. /
    13. In-Table List with Filtering Grouping and Ordering in HTML Document

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

    In-Table List with Filtering, Grouping, and Ordering in HTML Document

    Note
    In this article, we will use GroupDocs.Assembly to generate In-TableList with Filtering, Grouping, and Ordering report in HTML Document format.
    Note
    The code uses some of the objects defined in The Business Layer.

    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>>
    ManagerContract Price
    <<[key.getName()]>><<[sum(c => c.getPrice())]>>

    Download In-Table List with Filtering, Grouping, and Ordering Template

    Please download the sample template we created in this article:

    Generating The Report

    © Groupdocs 2001-2024. All Rights Reserved.