I am trying to repeat header row (column names) for each group of my report which are in the same page.
Please note that i know how to repeat headers on each page, but this is specifically related to repeating header rows on the same page but for each group as shown in the example below.
Please find below the steps which worked for me.
Step 1. Right click on the group 'Country'-->Insert Row --> Inside Group Above
Step 2.Right click on the group 'Country' which will now be a merged cell of 2 cells --> Split cells-->Cut the above cell which says 'Country' and paste to the cell below.
Step 3.Now you can see a blank row below your headers, cut and paste the headers to this blank row. It will repeat above each 'Country' group.