Export to Excel Header at fixed position

Question

Hi All 

 

I am using the Export to Excel from SSRS Report . after export to excel when i scroll the report section ,The Report

header (That is the column names) also scrolls and it become invisible , Is there any solution available to place the Excel report  Header at the Top 

 

Regards

Sooraj

Answer 1

The fixed columns within excel are called freezed panes. To add a fixed row pane,

1) click on the first cell in 2nd row (or the row where you data begins below the header)

2) In office 2007 click on view tab

3) Now click on freeze panes (you would see a horizontal line appearing above the line of the cell you selected)

Now when you scroll down, the top row would stay fixed.

hope this helps

 

---

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Answer 2

Hi,

You might find this link interesting. These is about setting of an custom rendering exetetion.

http://mysqlserverblog.com/2008/01/03/changing-export-options-for-reporting-services.aspx

 

---

-Chintak

Answer 3

Can we set the Freeze pane option in SSRS , rather than after Exporting to Excel 

 

Regards 

Sooraj

 

Answer 4

I am not sure if SSRS has one to do this while export. Meantime did you check what Chintak suggested?

Another alternative I can suggest is to have custom routine or vb script that can add the free pane programmatically. You could call this with a schedule after the files are generated (if you are using sheduled subscriptions).

How to programmatically add freezed panes? Please have a look at http://www.codeforexcelandoutlook.com/excel-vba/freeze-excel-panes-with-vba/

Regards

---

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH