# 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()))]>> |