How to Use Report Template Designer to Create an XLS File with Multiple Sheets?

Hi Stephen. Try this:

1. Open the report template in Report Template Designer.
2. In the Report Explorer pane, right-click the root node (probably "BOMQ") of the tree and select Properties from the pop up.
   
3. In the resulting Property Grid, expand the Export Options node found under Behavior, then expand XLSx Export Options.
4. Set Export Mode to "Single File (Page-by-Page)". Note: this option does not exist for XLS Export Options, only XLSx Export Options.
   
5. Save the template and export the XLSX report with Run Reports.

Of course, since it is possible to copy and paste selected cells from Excel onto a drawing, an alternative would be to export to a single sheet  then select the desired cells to copy, instead of exporting multiple, Location-specific sheets.

Hi Stephen. Try this:

1. Open the report template in Report Template Designer.
2. In the Report Explorer pane, right-click the root node (probably "BOMQ") of the tree and select Properties from the pop up.
   
3. In the resulting Property Grid, expand the Export Options node found under Behavior, then expand XLSx Export Options.
4. Set Export Mode to "Single File (Page-by-Page)". Note: this option does not exist for XLS Export Options, only XLSx Export Options.
   
5. Save the template and export the XLSX report with Run Reports.

Of course, since it is possible to copy and paste selected cells from Excel onto a drawing, an alternative would be to export to a single sheet  then select the desired cells to copy, instead of exporting multiple, Location-specific sheets.