Paginated reports exported to Excel always have blank row in Row 1. How do I get rid of it?

[SAS_BI]

Good morning, all!  I'm having an issue where all of my paginated report subscriptions that get exported to Excel insert a blank row into Row 1 before printing the table design.  Is there any way to get rid of this unwanted row before my users have to manually do it on their end?

Cheers,

Scott

[aduguid · Accepted solution]

Do you have a header in the report? If so, it could cause this. I use the following expression in the visibility of the header to hide it when exporting to Excel. 

=IIF(Globals!RenderFormat.Name = "EXCELOPENXML", true, false)

Otherwise it could be a gap between the tablix and the top of the report. I'd check the properties of the tablix and look at the top element. It should be 0.

[SAS_BI]

Thanks for the info!  I'm 99.9% sure there is no header, but I will double check, and check the gap between the tablix and the top of the report.

Cheers,

Scott

[aduguid]

If that doesn't work, you can post an example of the report .rdl in XML format and I can take a look. If you open .rdl files in a text editor it's just XML.

[SAS_BI]

I was able to eliminate the extra row in Excel by using you suggestion of pulling the Tablix all the way to the top of the report page.  Thanks again for the help!

Cheers,

Scott