I only have a header with a textox and a tablix on the report. There is no extra spacing in the body around these items, but I am getting extra rows sometimes when exporting to Excel. Does anyone know what is causing this and how to fix it? Thanks, KimKim B.

Kim, I would sugest verifying that your header is snapped to your tablix. if not, the free space between them will be translated as an extra row when exporting to excel. Same thing if your header is not snapped the the top of the page, you might end up with row before your header. As a side note, make sure you snap your header horizontally as well to the right and left of your page or specific columns. Otherwhise, you will end up with split and merged rows as well.

Kim, I would sugest verifying that your header is snapped to your tablix. if not, the free space between them will be translated as an extra row when exporting to excel. Same thing if your header is not snapped the the top of the page, you might end up with row before your header. As a side note, make sure you snap your header horizontally as well to the right and left of your page or specific columns. Otherwhise, you will end up with split and merged rows as well.

Hi Kim, You could have a check to see whether there is some space between textbox and tablix, please find out the location property of the textbox, type in 0in for top and left node, then find out the location property of the tablix, type in a value for top node, please make sure this value is just the height of the textbox, you could find this value in Size Property. After these steps, there is no space between these two items. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Kim, You could have a check to see whether there is some space between textbox and tablix, please find out the location property of the textbox, type in 0in for top and left node, then find out the location property of the tablix, type in a value for top node, please make sure this value is just the height of the textbox, you could find this value in Size Property. After these steps, there is no space between these two items. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thank you both. The textbox is in the page header with a location of 0in, 0in for top and left. It's size is 12.07293 in, 0.35in. The height of the text box is .35 which is also the height of the page header, so there is no exta spacing there. The tablix is in the body with a location of 0.0, 0.0 so it starts at the very top of the body. The textbox in the heading ends where the 4th column ends so that there isn't any problems with merged columns, extra columns etc. The only issue is an extra row sometimes whenever exported to Excel. We are seeing it across multiple reports. Kim B.

Hi Kim, I test your scenario in local environment, after been exported, everything works fine, in order to reproduce your issue, could you please send your exported excel file and give a demo report which exist your issue to sqltnsp AT microsoft DOT com, I would give your some check to the RDL report and give you the feedback as soon as possible, these file is a big help for us supply further assistance. Regards, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.