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

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

SAS_BI — Wed, 31 Jul 2024 11:22:05 GMT

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

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

aduguid — Wed, 31 Jul 2024 12:28:33 GMT

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.

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

SAS_BI — Wed, 31 Jul 2024 12:32:36 GMT

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

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

aduguid — Wed, 31 Jul 2024 12:36:35 GMT

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.

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

SAS_BI — Wed, 31 Jul 2024 12:48:32 GMT

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