Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-13 : 09:41:06
|
| 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? |
|
|
|
|
|
ssrs 2008 export to excel problem