Test Page

How Do I Freeze The Top Row?

Step 1

Deselect any existing related options. Right click on your table and select "Tablix Properties":

You want these options deselected:

Step 2 In the grouping panel click the far left drop down arrow to get advanced mode:

That will reveal "(Static)" grouping options:

Click into the table and then on the top left grey square to select the whole table:

Then click Row Groups – Static. The top cell of your first column will be selected:

Update to these properties: FixedData = TRUE KeepWithGroup = AFTER RepeatOnNewPage = TRUE

Step 3 The row headers have no background Fill colour set by default, if you Preview at this stage records will appear behind the headers as they scroll. Right click on each column header choose Textbox Properties and change this:

…to this:

How To Force Tables Onto Separate, Named, Excel Worksheets When Exporting

Right click on the table and choose "Tablix Properties". Add a page break after the table:

To name the destination worksheet, make sure the tablix is selected and look for the Properties Window and the Page Name property:

The second table should be as close as possible (0pt gap) to the previous with a different PageName for the destination worksheet: