1. Select a drop-down arrow beside column groups and enable "Advanced Mode" by clicking on it.
2. Then under Row Groups, select the static row and choose properties or press F4.
3. Set the following attributes for the static header row:
RepeatOnNewPage : True
KeepWithGroup: None