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 - Master-Detail
    12. /
    13. In-Table Master-Detail in Spreadsheet Document

    In-Table Master-Detail in Spreadsheet Document

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

    In-Table Master-Detail in Microsoft Excel Document

    Creating a In-Table Master-Detail

    Practising the following steps you can create In-Table Master-Detail Template in MS Excel 2013.

    1. Add a new Workbook.
    2. Select the range of cells that you want to include in the table.
    3. On the Insert tab, in the Tables group, click Table.
    4. Insert a 2x4 table.
    5. Save the template.

    Reporting Requirement

    As a report developer, you are required to represent the following key requirements:

    • Report must show each manager along with his total contract prices.
    • It must also show each individual client within the contract.
    • It must show sum of the contract prices.
    • It must represent all the information in tabular form.
    • Report must be generated in the Spreadsheet document format.

    Adding Syntax to be evaluated by GroupDocs.Assembly Engine

    Manager/ClientContract Price
    <<foreach [in getManagers()]>><<[getName()]>><<[getContracts().sum(c => c.getPrice())]>>
    <<foreach [in getContracts()]>><<[getClient().getName()]>><<[getPrice()]>><</foreach>><</foreach>>
    Total:<<[getManagers().sum( m => m.getContracts().sum( c => c.getPrice()))]>>

    Download In-Table Master-Detail Template

    Please download the sample In-Table Master-Detail document we created in this article:

    Generating The Report

    ODS Template and Report in Apache OpenOffice

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

    • We opened the ODS 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 ODS 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.