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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Export to excel sheet starts on row 2

Author  Topic 

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2010-07-01 : 15:19:57
Hi,

I am using SSRS 2005. I have a report with a few tables and a page break between them so that each table will be on a new worksheet.

When exporting to excel Sheet 1 starts on row 1 but the other sheets start on row 2 and this is a problem. How can I make all sheets display data from row 1. Also i noticed that the sheets following sheet1 start on row 2 and i don't see any row 1.

Here is an image of what i mean by starting at row 2 and there is no row 1

http://i844.photobucket.com/albums/ab6/collie_bucket/excel.jpg
My report design

http://i844.photobucket.com/albums/ab6/collie_bucket/design-2.jpg


Thanks


Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.
   

- Advertisement -