1. GroupDocs Documentation
    2. /
    3. GroupDocs.Assembly Product Family
    4. /
    5. GroupDocs.Assembly for .NET
    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

    Note
    In this article, we will use GroupDocs.Assembly to generate an In-Table Master-Detail report in HTML Document format.
    Note
    The code uses some of the objects defined in The Business Layer.

    In-Table Master-Detail in HTML Document

    Note
    This feature is supported by version 17.3.0 or greater

    Reporting Requirement

    As a report developer, you are required to represent customers’ orders information with the following key requirements:

    • Report must show each customer along with sum of prices of his orders.
    • It must represent all the information in tabular form.
    • Report must be generated in the Presentation Document.

    Adding Syntax to be evaluated by GroupDocs.Assembly Engine

    Customer

    Order Price

    <<foreach [in orders

    .Where(c => c.OrderDate.Year == 2015)

    .GroupBy(c => c.Customer)

    .OrderBy(g => g.Key.CustomerName)]>><<[Key.CustomerName]>>

    <<[Sum(c => c.Price)]>><</foreach>>

    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 with Filtering, Grouping, and Ordering Template

    Please download the sample document we created in this article:

    Generating The Report

    © Groupdocs 2001-2024. All Rights Reserved.