In a report definition created through the Report Designer, copying and pasting can be different than in a regular workbook in Excel. This is because business rules are applied not only on the cell level, but also on the report, row, and column level. This section will explain the rules for copy and paste for various business rule levels.

Cell level

The copy and paste rules in Report Designer are the same as for a regular workbook. By default, formulas and groupings are preserved.

Row/Column level

The copy and paste rules in Report Designer are the same as for a regular workbook when working in a single worksheet. By default formulas and groupings are preserved.

 

NOTE: If rows/columns are pasted into a different tab than the original source, groupings will not be preserved.

NOTE: If you want to copy and paste an existing group, you must copy the whole row/column, not just the cells where the information is.

 

Report level

The copy and paste rules in Report Designer for an entirely new tab require you to use a special copy menu. By using this menu, all formulas, groupings, and parameters are preserved.

  1. Right-click the desired tab to copy.
  2. Select OneStop Reporting > Copy.
  3. Right-click on a blank tab, then select OneStop Reporting > Paste as new.

 

 

  Pasting the tab will overwrite all information on the tab that was selected when taking the third step. It is very important to create a blank worksheet so that no data are lost.