Adding An Excel Worksheet to Management Report Designer
![](https://i0.wp.com/brightpointinfotech.com/wp-content/uploads/2017/08/8.worksheet-to-management-report-designer-v2-min.jpg?fit=1024%2C535&ssl=1)
- Create a new report; Row Definition and Column Definition.
- On the row definition, you will need to add a new row link. Click on Edit and Row Links.
- On the Link type, select External Worksheet, and name it appropriately.
- Your row definition will have an extra column.
- Create the excel sheet that you would like to link with the Report Designer.
- On the report designer, go to the link with the Row Definition and indicate the cell you’d like the report to pick data from. And add suffix /CPO.
- Create a tree definition, with the following details.
- Create a column definition.
- The reporting unit is set up as follows.
- The report definition looks like this.
Post Views: 457