Hi All,I am creating a report that uses a list that has page breaks. The breaks are grouped by a certain field. When exporting the report to excel, the page breaks translate to individual tab sheets. The question is can I name the tab sheets according to the field grouping applied to the list. Example the field grouping is department name. Therefore the tabs should be:Sheet1 = FinanceSheet2 = Human ResourceSheet3 = Project ManagementThanks & Regards,Fadzli

Hi Ayiezs, Yes you can give name to your tab sheets in excel . First try to get that in your visual studio priview. 1- you have some groupings in the list with the page breaks. 2- So try putting some group header row in your report. 3-Put the field name in the group header row as fields!department name.value. 4-Give the page break for the group property as "page break at start of the group" 5-So whenever you will get a new page after a group then you will get the sorresponding name in the header of the group also. 6- When you export the same to excel it will be exported to excel giving you the same result thats the group name or the page name/sheet name you can say. but let me say you wont get these names in the tabs of the excel sheet. As this is not supported to give name to the excel sheet with SSRS SP2. Hope you will get this Anyway let me know if you get the solution Thanks Mahasweta

Hi Mahasweta,Actually I have a report table in side of a list repeater.This list is where I placed the grouping and page break.So the table will show data based on the grouping.If I have 5 grouping in the list, the tables will be repeated 5 times and show data for each group.When transfering to excel, the tab sheet in excel is created based on the list grouping.The problem is, when transfered the group values are not visible in the tab sheet name.The tab sheet still will show 'Sheet 1', 'Sheet 2' until 5 tab sheets.The question is can I rename the tab sheets in the excel based on the list grouping?Thanks & Regards,Fadzli

Hi Fadzil, No its a known limitation. You cant rename the tab sheet. The rendering extensions in SSRS does not support to rename the excel tabs. Anyway Microsoft people can think of this . Thanks Mahasweta

Hi Mahasweta,Thanks for the info. Hope that Microsoft adds this feature in future.Regards,Fadzli

This feature was added in Report Builder 3.0. http://technet.microsoft.com/en-us/library/dd255234.aspx#WorksheetTabNames http://technet.microsoft.com/en-us/library/dd255278.aspx "To provide the sheet name, you set the PageName property of a table, matrix, list, group, or rectangle." "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."