You can create a sheet hierarchy in an eSpreadsheet report design by specifying a parent sheet in the Report Function tab of the Format Sheet dialog. There are at a couple of reasons this can help you.
1) It creates a dependency relationship. When a parent sheet is bursted, all child sheets are bursted with them, and positional information is maintained. The child sheets inherit their initial data subsets from their parent sheets.
2) Creating a hierarchy potentially changes the order in which sheets are processed. Normally sheets are processed left to right (i.e. the content of Sheet1 is created before the content of Sheet2). This often creates problems when a sheet contains Excel formulas that reference another sheet. In a sheet hierarchy, child sheets are always processed before the parent sheets, regardless of the order in which they appear. You can use this behavior to your advantage.