I am running SQL Server 2005 Reporting Services sp 2. When I create any 2 tables on a report, eliminate vertical spacing between them and insert a page break after the first table or before the second table, the second sheet's data always starts on the second row. All of the data is in tact but the sheet begins will a very small (vertically speaking) empty row and the data is displayed starting in row 2. I have tried removing padding, eliminating borders, adding/removing page headers, I have removed vertical spacing, tried using metric and US units but nothing works. I even started a new report and just added 2 small tables with a couple of rows of data and nothing else but still row 1 remains empty on the second sheet. I have searched for a fix and a few other people have come across the same issue but there doesn't seem to be a solution. Our client is very firm on this requirement so if there is no solution I will have to do this another way. Thanks in advance for any input.
BTW, I am setting up a subscription to render and send this report via email. It also does not work when I export to excel from the Visual Studio preview tab.