My ssrs report is to display order information. My first report page needs to contain a summary of all orders. My 2nd page contains the details of all orders. I have 2 separate stored procedures to select this data, and have created 2 separate datasets for these, within my ssrs report. My problem is I need to break these 2 datasets into 2 separate pages within my report, which I've been unable to do. How can I setup my report so I can split my ordersummary dataset and my orderdetails dataset into 2 separate pages? Thanks.

Go to 1st Table property -> Group -> Pagebreak -> Breaklocation and then select "End"

Hi As you have got two datasets it is always best practice to use list control in this case use two list control For first list control assign dataset 1 to it and for second list control assign dataset 2 to it now you can group this list control based on your grouping criteria apply group for both list if you have specifc column or just say nothing in grouping exp now in the group properties of list box 2 go to page break and select it hence it will work for you and also you can gather all requierd information in one area i.e free form designing of your report thanks

Hi Goalie35, Thanks for your post and other partners’ replies. In order to reach to your target, please use two data regions to display the ordersummary data and orderdetails data separately, such as two tables: Table1 and Table2. Bind dataset1 to Table1 and bind dataset2 to Table2. In SSRS 2005, 1. Right-click the border of Table1, select Properties. 2. In the General tab, check the checkbox of Insert a page break after this table below Page breaks. click OK. In SSRS 2008 and SSRS 2008 R2, 1. Right-click the handle of Table1, select Tablix Properties. 2. In the General tab, check the checkbox of Add a page break after below Page break options, click OK. Hope them help you. If you have any other questions, please let me know. Thanks, Sharp Please remember to mark the replies as answers if they help you and unmark them if they provide no help.