November 13, 2013 at 7:40 am
In an SSRS 2008 R2 existing report, I want to change the report so the users have the option to hide headers when they export the report to excel. By allowing the users to hide headers when they export the ssrs 2008 report to excel, they can sort and filter the data. This avoids allowing excel to display an error in a popup window saying there are merged cell.
My question is when I hide the headers and export the report to excel, there is a blank line in excel before the data and column headers appear.
Basically row # 1 in cell in blank and data and column headers show up starting in column #2.
Thus can you tell me how to remove the blank row in row #1 when the data is exported to excel?
November 19, 2013 at 8:14 am
Check the "location" settings of the very top object in the properties toolbar thingy usually on the left
Sometimes it can be set some really silly infinitely small number like 0.00000000302mm
Apologies for the simple language im still learning 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply