Hey! I'm an AI powered SmartBot.

How can I help you?

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

Leave a Reply