Adding An Excel Worksheet to Management Report Designer

  • 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.