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 Presentation Document

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

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

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

    Creating a In-Table List with Filtering, Grouping, and Ordering

    Practising the following steps you can create In-Table List with Filtering, Grouping, and Ordering Template in MS PowerPoint 2013.

    1. Add a new presentation slide.
    2. Press “Insert” tab to insert the table.
    3. Insert a 2x2 table.
    4. Save the template.

    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 Presentation Document.

    Adding Syntax to be evaluated by GroupDocs.Assembly Engine

    Manager/ClientContract Price
    <<foreach [in getContracts()
    .where(c => c.getDate().getYear() + 1900 == 2015)
    .groupBy(c => c.getManager())
    .orderBy(g => g.key.getName())]>><<[key.getName()]>>    		<<[sum(c => c.getPrice())]>><</foreach>>

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

    Please download the sample In-Table List with Filtering, Grouping, and Ordering document we created in this article:

    Generating The Report

    ODP Template and Report in Apache OpenOffice

    In order to check compatibility of ODP between Microsoft Office 2010 and Apache OpenOffice 4.1.2, we performed below tests:

    • We opened the ODP template created through Microsoft Office 2010 in Apache OpenOffice 4.1.2. The template opened successfully in Apache OpenOffice without any issues or formatting losses.
    • We opened the ODP report generated through GroupDocs.Assembly in Apache OpenOffice 4.1.2. The report opened successfully in Apache OpenOffice without any issues or formatting losses.
    © Groupdocs 2001-2024. All Rights Reserved.