# In-Table Master-Detail in Spreadsheet Document {{< alert style="info" >}}In this article, we will use GroupDocs.Assembly to generate In-TableMaster-Detail report in Spreadsheet 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 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/Client Contract 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: * [In-Table Master-Detail.xlsx](https://github.com/groupdocs-assembly/GroupDocs.Assembly-for-Java/blob/master/Examples/GroupDocs.Assembly.Examples.Java/Data/Storage/Spreadsheet%20Templates/In-Table%20Master-Detail.xlsx?raw=true) ### Generating The Report {{< gist GroupDocsGists f32bd70cf4ad82c5c1df41d61bd11e63 >}} ### 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.