Hi Guys, I am using SSRS 2005 and I have problem in page break when exported to excel. I have three seperate tables named Table1, Table2 and Table3 in my report. And my intention is When exported to excel all the three tables should appear in 3 seperate sheets. The Table2 and Table3 reports are used for internal users only. So they will be not visible to the end user (client). For Table1 and Table2, I selected the option 'Insert a Page Break after this table'. And For Table2 and Table3, I have written a IIF statement in the visibility section to make them visible only to internal users. Now When exported to excel, only two sheets are appearing with Table1 information on Sheet1 and Table2, Table3 information on Sheet 2. But What I want is all the three tables should appear in 3 seperate sheets. I tried a lot but couldnt figure out why the Table2 and Table3 are appearing in Sheet 2 and not on seperate sheets. Any ideas??? Thanks, Bablu

Hi, It is a known issue in Reporting Services 2005, please refer to the link below: https://connect.microsoft.com/SQLServer/feedback/details/125442/excel-export-fails-when-table1-is-conditionally-hidden-and-table2-configured-to-page-break-before Currently, as a workaround to the always export report to 3 separate sheets, please refer to the steps below: 1. Add 2 Rectangle to the report. 2. Place Table2 into the first rectangle and place Table3 into the second rectangle. 3. Disable Add a page break after of Table 2. 4. Enable Add a page break after of the first rectangle which contains Table 2. After that, when export report to excel, it will generate 3 sheets. However, by doing this the end user will also get 3 pages and the last 2 pages are blank. We appreciate your understanding. If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Hi, It is a known issue in Reporting Services 2005, please refer to the link below: https://connect.microsoft.com/SQLServer/feedback/details/125442/excel-export-fails-when-table1-is-conditionally-hidden-and-table2-configured-to-page-break-before Currently, as a workaround to the always export report to 3 separate sheets, please refer to the steps below: 1. Add 2 Rectangle to the report. 2. Place Table2 into the first rectangle and place Table3 into the second rectangle. 3. Disable Add a page break after of Table 2. 4. Enable Add a page break after of the first rectangle which contains Table 2. After that, when export report to excel, it will generate 3 sheets. However, by doing this the end user will also get 3 pages and the last 2 pages are blank. We appreciate your understanding. If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help