when I export a excel file throuh ssrs 2008 then i got in print preview of excel table header is not repeating
on each page. I have done the advance mode setting like :
But still not getting table header on each page, but it works in pdf format.
Please sussgest me any idea. I also try to put text box in page header and try to get what i want to get
through table header but get another issue which is not fit for my report.
Please suggest me, what i have to do for getting table header on each page.
Thanks in Advance
Exporting to Excel defaults so that it is optimized for viewing on screen.
Use the InitialPage property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the PageName property to provide different names for each worksheet. Each new report page, defined by a page break, is exported to a different worksheet named by the value of the PageName property. If PageName is blank, but the report has an initial page name, then all worksheets in the Excel workbook use the same name, the initial page name.
For more information:
Pagination in Reporting Services
Exporting to Excel (SSRS)