Hi, I have a report which has a group and I want to basically start the following group on an odd page. So when users print the report on the double sided setting each group can be split up as a separate report

Hi Nasa, Page breaks can be added to report items such as a table, matrix, list, chart, gauge, or image. You can also add page breaks to groups in a table, matrix, or list. Page breaks can be added before, after, and between groups. However, you can add page breaks base on page number is odd page or not. This is because page number is depended on page breaks. Different kinds of page break can cause different page number. For more information about Controlling Page Breaks, please see: http://technet.microsoft.com/en-us/library/dd255207.aspx In your scenario, you can add a blank page on the exported file base on page number, if a new group display on odd page, add a blank page before this new group. In this case, each group can be split up as a separate report. If you have any questions, please feel free to ask. Regards, Charlie Liao

Thank you for your answer, how do you add a blank paged to an exported file based on the page number, so that when printing each report can be split up. Thanks

Hi Nasa, When you export your report to word, you can add a Blank page or Page Break at anywhere you want. The screenshot below is for your reference: If you have any questions, please feel free to ask. Regards, Charlie Liao

Hi Charlie, Thanks for this but this is a manual process, I want the page break to be done automatically within the report viewer, is this possible??? Thanks

Hi Nasa, I am afraid there is no such a feature to achieve your requirement in Reporting Services currently. Personally, I recommend you submit this suggestion at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to improve it in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided. Regards, Charlie Liao

Thanks Charlie, I will put in a suggestion as I think it really is needed.