Hi, I have a scenario to group the records based on a particular column, but my problem is the report is showing the half of the records in next page sometimes, for ex: Report: Page 1: Patient Name Patient ID Age Sex DateofAppointments AAA 100 35 M 10/14/2009 100 35 M 11/29/2009 100 35 M 12/16/2009 100 35 M 06/06/2010 . . . . . . DDD 105 26 F 6/04/2010 105 26 F 08/06/2010 Page 2: 105 26 F 09/06/2010 105 26 F 10/14/2010 EEE 106 45 M 05/05/2009 106 45 M 06/19/2010 If you see the above results, I have grouped the report based on Patient name, here Patient DDD details are coming in the next page, is there anyway to avoid to details continuing in the next page in SSRS 2005.. I mean, particular patient details should be end within the page, in next page should starts with another new patient... Thanks in Advance.... Regards, Fazlu

Hi Fazlu, You need to add a "page break" after [Patient ID] group.Sergei

Hi Fazlu, You need to Modify the group property. In the "page break" Tab need to click the check bob "Between each instance of the group". Please see the below image for more details. SUHAS http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thanks.. BUt I am using SSRS 2005, this option is available on SSRS 2005 also Regards, Fazlu

Hi Fazlu Yes this Option is available in SSRS 2005. You just need to Write click on the group you created as show in Image. Then go to "page break" Tab and just click on "Between each instance of the group"SUHAS http://suhaskudekar.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Fazlu, In your case, we can try to add a group and group by "PatientID", and then add a page break on the "PaientID" group. For more information about adding a page break, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms156434(v=SQL.90).aspx If you have any more questions, please feel free to ask. Regards, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Fazlu, In your case, we can try to add a group and group by "PatientID", and then add a page break on the "PaientID" group. For more information about adding a page break, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms156434(v=SQL.90).aspx If you have any more questions, please feel free to ask. Regards, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.