Hi, I have a SSRS report which will create a report in Pdf. My Requirement is: Lets say I have five records.Now this records are just displaying one after the other. What I want now is Each and every record should start from a new page. ie.Record 1 should start from new page,record 2 from new page and so on. How can I acheive this. Please help me. Thanks, A2HThanks, A2H

Hi, I have a SSRS report which will create a report in Pdf. My Requirement is: Lets say I have five records.Now this records are just displaying one after the other. What I want now is Each and every record should start from a new page. ie.Record 1 should start from new page,record 2 from new page and so on. How can I acheive this. Please help me. Thanks, A2H Thanks, A2H Page break at each record thats it . ThanksRajkumar Yelugu

Hi, On SSRS 2008 or 2008 R2, you can perform followings setps 1) Go to the grouping pane at bottom 2) Right click on details and setct group properties 3) Go to page break tab 4) Click Between each instance - Chintak (My Blog)

Hi All, I am using Sql Server 2005. And I am not able to see a way to set pagebreaks. Can any one please help me how to set page breaks in sql server 2005. Thanks, A2HThanks, A2H

Hi A2H1986, Please follow these steps to get your requirement for setting page breaks in sql server 2005: 1. Right-click the detail row, then select edit group. 2. You will see checkbox of Page break at end. 3 Select this checkbox. Then one record will be show on one page, please make sure you have a group expression. Otherwise you will get the error. If there exist some records are same, I think you could add a parent group grouped by =Rownumber("tablename") then do the same as top steps. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.